I have a chart where I am showing Builds sorted by total cases open against them.
In order to show top 10 builds, I created a calculated field named 'Rank' and used INDEX() as the calculation. Dragged it on the Rows, converted it to discrete and ended up with following chart.
The above chart is totally fine. Problem is now if I add 'Status' field in Color mark, it breaks the chart incorrectly like below:
How can I show ranking of Builds and have it colored by Status?
I tried to research online and played around for a whole day, but still not getting the solution. Any help is appreciated.