Summary number displaying the wrong number

Hello, I'm trying to display the total number of conversions in the summary number. In the graph, it is displaying the correct number by day but when trying to display the total in the summary number is missing 6 conversions. 

Here is the beast mode used:
COUNT(DISTINCT(CASE WHEN
(`a.accepted_migration` = DATE(`c.call_date`))
AND
(`b.event`NOT LIKE '%MIGRATION%')
AND
(`c.call_date` >= `b.visit_date`)
then `a.unique_id`
end))

 

thanks

Comments

  • jaeW_at_Onyx
    jaeW_at_Onyx Budapest / Portland, OR 🟤

    turn your visualziation into a table card and take everything off the axes except the beast mode.  is it the same as the summary number?

  • Hello @jaeW_at_Onyx so the setup is correct. It is showing in graph line the correct numbers for each day but when adding the Summary Number it is missing about "30" to the sum. 

  • GrantSmith
    GrantSmith Indiana 🔴

    Hi @user054934 

     

    Likely this is because your data is being partitioned by day in your graph but being calculated across your entire data set for your summary number. So if you had a unique ID for multiple days on your summary number it would be counted once under your distinct summary count but would appear in multiple days because it would be distinct to that day and not the entire date range. 

  • GrantSmith
    GrantSmith Indiana 🔴

    To confirm this do not select to graph by day but remove your date from your table chart and your summary number as well as the number in your chart table should be the same

  • @GrantSmith yeah that makes a lot of sense. Is there a way to display in the Summary Number the sum of distinct values by day? I mean the correct sum of all the values displayed in my chart.

This discussion has been closed.