Count Distinct Variance

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!

Answers

  • MarkSnodgrass
    MarkSnodgrass Portland, Oregon 🥷

    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.

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.