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%
Lookup of first rank for every week
LOOKUP(rank(sum(sales),'desc'),0) = 1
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...