How to Display Distinct Order Numbers in Edit Path
I am in need of assistance of how I could display only distinct order numbers while drilling down on a card. I am able to to get my summary number and chart to show me 4 distinct order numbers, however, when I drill down on the chart, it'll show me a total of 5 order numbers.
This is what the chart looks like:
|ErrorDescription||Number of Errors|
When I drill down on one of the errors, and exit out of the drill down, it'll show me a total of 5 orders.
OrderNumber 1 is duplicated, and I understand it is because there are two separate error descriptions, but is there a way to only show 1 order number regardless of how many different error descriptions there are?
Ideal End Result: