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 Date | Weekday of Order Date | Sum(sales) | Lookup of first rank for every week LOOKUP(rank(sum(sales),'desc'),0) = 1 |
|---|
| Week 49 | Thursday | 6,062 | 1 |
| Week 50 | Monday | 3,080 | 1 |
| Week 51 | Wednesday | 6,121 | 1 |
| Week 52 | Monday | 7,485 | 1 |
| Week 53 | Monday | 1,381 | 1 |
| Weekday of Order Date | Count of weekday for December 2012 | OUTPUT |
|---|
| Monday | 5 | 60% |
| Tuesday | 4 | 0% |
| Wednesday4 | 4 | 25% |
| Thursday | 4 | 25% |
| Friday | 4 | 0% |
Thanks,
Sridhar
