Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
As shown in the below bar graph( part of a trellis chart), it has the count of complaints for a region based on certain criteria. I have set the dimension limit(for Product component) to top 15. Now I need to find the total of the values on the data points(i.e 221) and display in in the title for each section of the trellis. The Trellis dimension is a dealer name.
the expression that used for the count in this chart is
=Count({<CAL_YEAR={'$(=Max(CAL_YEAR))'},CAL_QUARTER={$(vPrevQuarter)},DealerZone={'WEST'}>}[Complaint Number])
Require further help. Thanks in advance
Would you be able to share your sample app to look at this?
I don't have a sample application but I tried using this expression to get the sum.
=Sum(aggr(Count({<CAL_YEAR={'$(=Max(CAL_YEAR))'},CAL_QUARTER={$(vPrevQuarter)},DealerZone={'WEST'}>}[Complaint Number]), [Product Component]))
It shows the SUM for but not just the top 15. I need to find the sum for the top 151 only.
May be use, Rank function like this
=Sum(aggr(Rank(Count({<CAL_YEAR={'$(=Max(CAL_YEAR))'},CAL_QUARTER={$(vPrevQuarter)},DealerZone={'WEST'}>}[Complaint Number]))<=151, [Product Component]))