7 Replies Latest reply on Oct 25, 2016 6:31 AM by David Li

    Ranking market thats been "green" the longest

    Sam Holmes

      Hi all,

       

      My client has requested a view which shows a ranking of markets based on a KPI being in the green status.

       

      Now Rank 1 would be the market which has had the Green for the most consecutive months etc.

       

      I know this is possible in Tableau (version 9) but I am drawing a complete blank on how to go about it.

       

      I would be grateful for any assistance the community can offer, and thank you in advance!

       

      example

       

       

      Net profit =1) France green for 5 months
                        2) Belguim 4months