2 Replies Latest reply on Nov 5, 2012 7:38 PM by Carl Johan Ragnarsson

    Top N by last date of a time interval

    August Guadamuz

      Hi Tableau Community,


      I am having difficulty arranging my top 20 data.


      I am working with customer service data and have incoming support incidents partitioned by category and addressed by date.


      The worksheet displays the last 7 days of incident data.


      My goal is to show the top 20 categories ordered by the most recent day of the 7 day interval.


      Is there a way to rank the dates from 1-7 and then set a top N filter that will use the rank of seven as the basis for determining the top 20?


      Thank you.