Forum Discussion
thenerv25
5 years agoFrequent Visitor
Top Performer Comparison
I'm hoping to understand what would be the most efficient way to incorporate a dynamic comparison to a top performing teammate on a given measure. For example, I have a dashboard that is intended to ...
- 5 years ago
https://drive.google.com/file/d/1VRaQzLoF4WUswZceW9gZx5T-aqHOqHxJ/view?usp=sharing
use this file and see whether it works. Actually when you apply an external filter,
The Data gets restricted and only shows the filtered data hence other one will not show up.
Another way (if above file is not useful) To Show that value you need to create another visual Like Card and restrict the interaction so taht the card will show the Top Value
VijayP
Community Champion
5 years agoCreate this measure and add this to the regular Chart what you have created and this will give the context what you require
RANKOFEMPLOYEES = RANKX(all(empid),YTD,,DESC)
Return
Calculate(YTD , filter(all(empid),rankofemployee=1))
Please share your Kudoes and you can watch my Videos on www.youtube.com/perepavijay