Forum Discussion
Helper IKPI visual - Low is good
Helper IHi v-huizhn-msft,
so you say that when "Low is Good" is set, goal is 13% and value is 10,9%, then distance is "+16,15%"? But this cannot be right, its mathematically wrong!
Distance between 10,9% is always less than 13% by 16,15%, so there has to be -. Similarly 15,1% is always higher than 13% by 16,15%, so there has to be +. Option between "Low is Good" and "High is Good" should affect just color and check/exclamation mark, not a math. sign.
I understand what you mean that when value is better than plan, there should be + and when value is worst than plan, there should be -. However minus sign doesnt have to be interpreted as negative, resp. bad. It can easily be positive, resp. good. And its even common practice in other BI tools for Low is Good KPIs. KPI Indicator works that way too.
I dont understand reference on Sean post, because in first part he just demonstrates, how to solve +/- issue by change color in "High is Good" mode, but finds out then there is issue with check/exclamation marks. In second part he shows that KPI Indicator custom visual works correctly. Basicly he confirms what I am saying all the time.
Best,
Jiri
Community ChampionOkay hopefully an example may help explain the issue better :smileyhappy:
Imagine you are acquiring different properties that have asking prices.
Think of the 13% GOAL as the limit of what you are authorized to go over the asking price with no need to contact management!
That's why Low is Good! (so if you have $1,000 asking price you can go up to $1,130 immediately on the spot)
However lets say in this case there's more interest in this property and you have to acquire it!
So you call and get an authorization to slowly go up to say 18% over the asking price
So you start bidding higher in steps and you end up getting the asset for 15.1% over the asking price
Therefore you end up paying 15.1% premium on the asking price in total
So you went OVER the 13% you are allowed PLUS additional and that's why we need the + sign and in red!
It does seem that the Low is Good setting on the built-in KPI should be adjusted
I may copy and paste this post in the Issues Forum later
BTW (I have other issues with the built-in KPI that I've been delaying posting about... hopefully soon)
- jiri_siroky