Charting

Charting

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

  • 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.

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In