So i'm trying to LEFT JOIN my table deal on lead, but its not giving me back the result i want... I want to visualisize all the leads and deals that have the same lead_id on one line so i can use one date as dimension and 2 counts (lead & deal)
LIB CONNECT TO 'lead (-----------)';
[id] AS lead_id,
DATE(inserted, 'DD/MM/YYYY') as lead_inserted,
[name_last] AS lead_name_last,
[priority] AS lead_priority,
ApplyMap('lead_sourceMap',[source], null()) AS source,
i have tried all the joins. If i do an INNER JOIN they align in a row, but then i miss all the leads that have not became deals... With the JOIN or LEFT JOIN i have values in the column deal_id, deal_inserted etc. But they are not in one single row...