Count Distinct Number Changes
I've run into a really weird problem, that I'm curious if any one has ever seen it:
I have a beast mode that counts the number of orders based on their unique identifier. The formula is:
I have a combo bar/line graph that shows number of orders & revenue by month. I noticed that the order count was really high (See "Incorrect Number of Orders (1).png"). Showing 442 for March. When I exported the underlying data from the same data set, I noticed that the actual number of distinct "Names" was 336 for March.
I then duplicated the card and added in another column that counts the distinct number of lines for the month in a bar next to the number of orders. (a "line" represents a item/order combo. You can have multiple lines/order). That is the ONLY thing I changed between the 2 graphs, and my Count(Distinct `Name`) function changed values to the correct 336 number for March (see screenshot "Number of Orders Correct (1).png"). The other card without the 2nd bar is still showing the incorrect number of orders
So my count distinct formula changes based on the other columns that are in the bar? Makes no sense to me. I've opened a case with domo support, but am curious if any users have experienced this before.