Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a simple bar chart with Name as dimension and Revenue as expression. There are thousands of long names, so the x axis is very cluttered. I would like to replace the Names with a simple count (1, 2, 3, 4) so that the names are anonymous but identifiable, and the x axis is less crowded. Is this possible?
=Aggr(Rank(Sum({$<NAME=>}REVENUE)), NAME)
and
=Aggr(Rank(Sum({$<NAME=>}REVENUE)), NAME)&': '&NAME
Hello totinmic
Please see attachment,
Hi,
I added a numerical reference in the legend to your solution:
maybe it helps
regards
Marco
Thank you, very helpful!
When I make a selection on Names, it resets the rank. For example, if I select the Names ranked 11-20, the x axis resets to 1-10. How do I adjust the formula to disregard the current selection of Name?
=Aggr(Rank(Sum({$<NAME=>}REVENUE)), NAME)
and
=Aggr(Rank(Sum({$<NAME=>}REVENUE)), NAME)&': '&NAME