I have a question about the total of the count distinct column.
This column (Users) has “count disctinct” setting turned on.
If we sum 8953+7667+107+41 = 16 768 which is slightly more than total on screenshot 15 199.
I’m explaining this fact to myself like that : when the QS calculates the total, it does not just sum up the column, but takes all users for the period and counts their unique number without taking into account the dimension. Am I right?
Thank you so much for your time and answers!
I wanted to just say yes, but the site requires 20 chars. So I am writing an essay.
QS “Total” of “count(distinct)”
total of distinct users in your datasets.
You didn’t show the “group by” column in your screenshot,
So for ref. I am calling it the role.
So if any user with multiple roles, will appear in your table twice, and “distinct count” of values will only count it once / role while
total will only count it once.
table visual will show