Chart total wrong

[david_ze]

hi,

I have a strange issue...

I use straight table: Dimenssion is Date and have about 12 expressions 10 of them are sum(XXX).

Rest are Count expressions and their totals are wrong...the expressions are:

count(DISTINCT initiated_users)

count(DISTINCT slideUp_users)

I've exported the data to excel and saw that only in these columns the total is not right.

will appreciate your advice.

Thanks in advance

David

[brenner_martina]

Hi David,

do you have any syntetic keys in your data model? And what is wrong?

[david_ze · Accepted solution]

No, don't have syntetic keys. The thing is that the total is not correct in these two tables.

[kji]

Check which kind of total you are using, most likely you have it on "Expression Total" but want to use "Sum of Rows".

[#5]

Hi David, the issue here might be that the default expression for populate the total's row is the "expression total" meaning that the expression count(DISTINCT initiated_users) is evaluated without a single dimension, the difference you noticed when you exported the data is because there are values of initiated_users that might be repeated across different dates; this way the total row will always show the count of distinct initiated_users in all the dates available. If you want to sum the rows within the count expression just check the "sum of rows options" under the expressions tab. Another option could be using a expression similar to the following:

sum(aggr(count(DISTINCT initiated_users) ,Date))

Hope this helps.

Regards

[david_ze]

John thanks,

I've changed it to sum of rows and it works perfect.

Thank you all for helping

David