1 Reply Latest reply on Aug 21, 2016 1:48 PM by SRIDHAR SRIRANGAM

    Percentage of first rank for weekdays in a month

    SRIDHAR SRIRANGAM

      Hi ,

       

      I m not able to get the Percentage of first rank for weekday in a month. I'm using tableau 8.3 /9. It would be great if we have solutions for this. I have attached workbook for your reference.

       

      Percentage of first rank for every weekday = number of times first rank based on sales / count of weekday

       

      For example December 2012 ,The output I'm expecting is

       

      Monday -> count of weekday is 5. Number of first time first rank is 3 so it will 3/5 = 60%

      Tuesday -> 0/4 = 0%

      Wednesday -> 1/4 = 25%

      Thursday -> 1/4 = 25%

      Friday -> 0/4 = 0%

       

       

      Week of Order DateWeekday of Order DateSum(sales)

      Lookup of first rank for every week

      LOOKUP(rank(sum(sales),'desc'),0)  = 1

      Week 49Thursday6,0621
      Week 50Monday3,0801
      Week 51Wednesday6,1211
      Week 52Monday7,4851
      Week 53Monday1,3811

       

       

       

      Weekday of Order DateCount of weekday for December 2012OUTPUT
      Monday560%
      Tuesday40%
      Wednesday4425%
      Thursday425%
      Friday40%

       

       

      Thanks,

      Sridhar