2 Replies Latest reply on Aug 1, 2018 7:49 AM by Lukas Kulhanek

    Ranking a stacked bar chart

    Lukas Kulhanek

      It seems like a very simple problem, but I suspect that I have encountered a bug in Tableau. I would like to rank stacked bars by their overall count (not specific categories). It will then look like the following image, as you can see, the "higher" entries are showing a correct rank, but some split up into the categories (even/odd). In this sample data, only few rows are affected, with my operational data this error occurs for almost every entry.

      Chart sample.png

      The rank is done via

       

      RANK(MIN({ EXCLUDE [Zip Even/Odd]: COUNTD([Postal Code])})).

       

      How can I make sure, all entries are ranked correctly?