I read many discussions about usage of rank function and sorting different things and have no idea how to solve my problem .
I want to create a ranking of top 10 persons who take the highest number of meetings (monthly) using pivot table (or other table, chart etc. - something that will show data in correct order). So I want to have ranking (numbers from 1 to 10) as a first dimension in rows, months as a second dimension in columns and the names as a value. The names should be sorted by the highest volume of meetings for person taken in eachparticular month, so the order of names will differ in each column (month). Please help me with that, because I'm running out of the ideas how to do it.
Now I'm working on a layout of this table. I'm trying to add a background color for every person on the rank list. The color depends on group to which the person is asigned, for ex. sales with blue color, marketing with red. Now it's not working when I add the expression with if(group='sales',blue(255)) etc. If you have an idea to solve this, I will be very grateful... Now I'm trying to do it myself, but with no results.
Re: TOP 10 meeting takers in month - ranking function
Ok, I added 4 groups to my sample.
The problem is that your color expression is also evaluated in the context of your dimensions, RankID and Month. A group is ambiguous in this context, probably all groups are returned in the records for the Month (and RankID is a Data island). So you need to use an expression for your color selection, that returns the group for the appropriate RankID and Month.
So I just reused our above expression in a color pick (Group is just a numerical in my sample):