Hi Guys,
I just have a hurdle that is driving me crazy. I would like to create a gauge that has simple structure.
=min({<Names=>}total aggr(avg({<Names=>}[Nbr of Orders]),Names)) - lower bound
=max({<Names=>}total aggr(avg({<Names=>}[Nbr of Orders]),Names)) - upped bound
and the bounds in the middle like
=max({<Names=>}total aggr(avg({<Names=>}[Nbr of Orders]),Names)) * 0.2
=max({<Names=>}total aggr(avg({<Names=>}[Nbr of Orders]),Names)) * 0.4 etc
I am after checking certain person performance vs all. However, I missed to noticed that the Nbr of Orders refers to several KPIs and I am after a certain KPI only.
How can I restrain it to show me the info for only 1 KPI
This formula below simply does not work:
=max({<Names=>}total aggr(avg({<KPI = {'DesiredKPI'}>}{<Names=>}[Nbr of Orders]),Names))