Finish My Question In SQL To Make A Wonderful Dashboard

HELP :pray:
:fire: Hello everyone, I hope your week is starting great !!! :sunglasses:

To give you a little bit of context, I am working on a project which gets data from Lemlist (Cold emailing software) and displays it in a wonderful dashboard (Custom question with SQL) on Metabase.

On Metabase, I am assessing the rates for each email campaigns (Email Sent / Open Rate / Clicked Rate / Replied rate / Interested Rate), however, I want to have the unique number corresponding to that percentage.
To make it more visual, this is what I have in the Lemlist reports (1st picture) and this is what I want to be able to see in Metabase (2nd picture), but I don't know how to the get the unique numbers corresponding to the various percentages.

Please help :slight_smile:

Hi @Arnaud
Without knowing the data structure, then it's not possible for anyone to guess that either.
Try posting the query you have. It's really not a question about Metabase, but a regular SQL query question, so you might find better help on a forum dedicated to the database you're querying or stackoverflow.com

@flamber Thanks for your answer,
Please find below the query:
select PROFILE_LEMLIST_CAMPAIGNS_NAMES, "Open Rate", "Click Rate", "Reply Rate"
FROM(
SELECT "source"."PROFILE_LEMLIST_CAMPAIGNS_NAMES" AS "PROFILE_LEMLIST_CAMPAIGNS_NAMES", "source"."sum" AS "sum", "source"."sum_2" AS "sum_2", "source"."sum_3" AS "sum_3", "source"."sum_4" AS "sum_4", "source"."sum_5" AS "sum_5", "source"."sum_6" AS "sum_6", "source"."sum_7" AS "sum_7", "source"."Open Rate" AS "Open Rate", "source"."Click Rate" AS "Click Rate", "source"."Reply Rate" AS "Reply Rate"
FROM
(SELECT "source"."sum" AS "sum", "source"."sum_4" AS "sum_4", "source"."sum_5" AS "sum_5", "source"."sum_6" AS "sum_6", "source"."PROFILE_LEMLIST_CAMPAIGNS_NAMES" AS "PROFILE_LEMLIST_CAMPAIGNS_NAMES", "source"."sum" AS "sum_2", "source"."sum_2" AS "sum_2_2", "source"."sum_3" AS "sum_3", "source"."sum_4" AS "sum_4_2", "source"."sum_5" AS "sum_5_2", "source"."sum_6" AS "sum_6_2", "source"."sum_7" AS "sum_7", (CAST("source"."sum" AS float) / CASE WHEN "source"."sum_4" = 0 THEN NULL ELSE "source"."sum_4" END) AS "Open Rate", (CAST("source"."sum_5" AS float) / CASE WHEN "source"."sum_4" = 0 THEN NULL ELSE "source"."sum_4" END) AS "Click Rate", (CAST("source"."sum_6" AS float) / CASE WHEN "source"."sum_4" = 0 THEN NULL ELSE "source"."sum_4" END) AS "Reply Rate" FROM (SELECT "DBT_DB"."MODELS_FINAL"."FINAL_LEMLIST_TEAM_PROFILES"."PROFILE_LEMLIST_CAMPAIGNS_NAMES" AS "PROFILE_LEMLIST_CAMPAIGNS_NAMES", sum(CASE WHEN "DBT_DB"."MODELS_FINAL"."FINAL_LEMLIST_TEAM_PROFILES"."PROFILE_LEMLIST_EMAILSOPENED_COUNT" > 0 THEN 1 ELSE 0 END) AS "sum", sum("DBT_DB"."MODELS_FINAL"."FINAL_LEMLIST_TEAM_PROFILES"."PROFILE_LEMLIST_EMAILSOPENED_COUNT") AS "sum_2", sum("DBT_DB"."MODELS_FINAL"."FINAL_LEMLIST_TEAM_PROFILES"."PROFILE_LEMLIST_EMAILSSENT_COUNT") AS "sum_3", sum(CASE WHEN "DBT_DB"."MODELS_FINAL"."FINAL_LEMLIST_TEAM_PROFILES"."PROFILE_LEMLIST_EMAILSSENT_COUNT" > 0 THEN 1 ELSE 0 END) AS "sum_4", sum(CASE WHEN "DBT_DB"."MODELS_FINAL"."FINAL_LEMLIST_TEAM_PROFILES"."PROFILE_LEMLIST_EMAILSCLICKED_COUNT" > 0 THEN 1 ELSE 0 END) AS "sum_5", sum(CASE WHEN "DBT_DB"."MODELS_FINAL"."FINAL_LEMLIST_TEAM_PROFILES"."PROFILE_LEMLIST_EMAILSREPLIED_COUNT" > 0 THEN 1 ELSE 0 END) AS "sum_6", sum(CASE WHEN "DBT_DB"."MODELS_FINAL"."FINAL_LEMLIST_TEAM_PROFILES"."PROFILE_LEMLIST_EMAILSINTERESTED_COUNT" > 0 THEN 1 ELSE 0 END) AS "sum_7" FROM "DBT_DB"."MODELS_FINAL"."FINAL_LEMLIST_TEAM_PROFILES"
[[WHERE "DBT_DB"."MODELS_FINAL"."FINAL_LEMLIST_TEAM_PROFILES"."PROFILE_LEMLIST_TEAM_NAME" = {{ name }}]]
GROUP BY "DBT_DB"."MODELS_FINAL"."FINAL_LEMLIST_TEAM_PROFILES"."PROFILE_LEMLIST_CAMPAIGNS_NAMES"
ORDER BY "DBT_DB"."MODELS_FINAL"."FINAL_LEMLIST_TEAM_PROFILES"."PROFILE_LEMLIST_CAMPAIGNS_NAMES" ASC) "source") "source"
LIMIT 1048575
)