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.