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

# Percentage of first rank for weekdays in a month

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

• ###### 1. Re: Percentage of first rank for weekdays in a month

Any pinter?