Count Distinct Variance

chrissy

Hello,

I am currently creating a bar chart where I use a count distinct formula for unique client IDs as the y-axis, and the series is location. I've noticed that when i add or remove the series from the bar chart, the y-axis's values change. I'm not sure what is going on, any advice would be helpful. Thanks!

MarkSnodgrass

Your differing values is because you likely have a client id in multiple locations. For example, if your data looks like this:

Your distinct client id count is 3.

However, when broken out by location, your counts look like this:

Denver - 2

Boston - 1

Austin - 1

Adding those totals up equals 4 because client ID A is in two different cities. You should expect different counts because clients are in multiple cities.

Hope this helps.