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!





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