10 Replies Latest reply on Apr 14, 2017 9:21 AM by Srinidhi Narayan

    Need Help Creating Consecutive Sets

    Alex Chun

      Hello Tableau Community!


      I am trying to figure out if it is possible to create consecutive cohorts for a dimension sorted on a given measure. My end goal is to create a dimension or calculated field of some sort that I can then apply as a Color Mark on a stacked line graph over a certain period of time.


      Something similar to this ...

      Screen Shot 2017-04-03 at 4.01.17 PM.png


      So essentially create 4 cohorts that group the dimension in the following manner:


           Set 1: First 1-50 items within a dimension

           Set 2: Next 51- 250

           Set 3: Next 251 - 500

           Set 4: Other


      Tableau makes it easy to create Top N and Bottom N sets, but doesn't have the option to do in between..Any suggestions would be greatly appreciated!