1 Reply Latest reply on May 3, 2018 3:48 PM by rock star

    'Rank' messing up the chart

    rock star

      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.

      1.png

      The above chart is totally fine. Problem is now if I add 'Status' field in Color mark, it breaks the chart incorrectly like below:

      2.png

       

      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.

      Thank you!!