Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am looking to set the value of one field based on the output of a rank expression. For example, if I have total sales by sales person, and I rank those sales from highest to lowest, I want to populate a field (SalesLevel) based on that ranking. The top three would be "Gold Level", the next seven would be "Silver Level", the next 10 would be "Bronze Level"
maybe, in a chart with salesperson as dim, this expression
if(rank(sum(Sales),4)<=3, 'Gold',
if(rank(sum(Sales),4)<=10, 'Silver',
if(rank(sum(Sales),4)<=20, 'Bronze',
'nothing'
)))
maybe, in a chart with salesperson as dim, this expression
if(rank(sum(Sales),4)<=3, 'Gold',
if(rank(sum(Sales),4)<=10, 'Silver',
if(rank(sum(Sales),4)<=20, 'Bronze',
'nothing'
)))
That gives me what I was looking for. Thank you for your quick response.