Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hierarchy Ranking based on measure

Hello,

I have a measure that calculates the days passed since a salesman made his last sale.

I would like to create a ranked bar graph that shows the top/bottom salesmen based on my measure

My hierarchy is branch ->salesman (so if i drill down in a branch, I see the salespeople working there).

I would like my ranking to to find the "worst" salesmen but only from the "worst" branches.

So this is kind of a double/embeded ranking.

 

Finally, is there a way to add a tiebreaker in the ranking? Because if I have 20 salesmen with the same "days since last sale" then I see them all in the ranked graph. Is there a way to determine which ones I will see instead of all of them with the same "score"?

This is why I thought of the "worst" salesmen but only from the "worst" branches "solution". So it would kind of act as a filter/tiebreaker. 

Is there a better way to do something like this?

Thank you.

2 Replies