Bar Chart -- Add Unique or Count Distinct to Axis/Series Aggregation
I am building a card to reflect work completion status and found repeating IDs are counted repeatedly. Is there any way to have "unique" or "count distinct" function there? Source data is attached too.
Please see the image below for comparison between data shown on a stacked bar chart & sumo card. Please understand: I cannot use Sumo card as I need to drilldown to further details. Of course, if Sumo cards is made drill-path enabled, then there is no issue.
The expected result is to have "6" (unique count) shown on WIP portion of the bar chart.