on 10-21-2016 01:14 AM
Could a moderator please advise me as to why I have been added to the Norway usergroup?
I do not live in Norway and I keep getting notifications of posts in this group -- and I can't seem to remove myself from it.
10-21-2016 02:10 AM - edited 10-21-2016 02:22 AM
the KPI visual compares two values in addiction to a criteria and show you the trend / progression.
In my example I have a Customer as trend, a measure which calculate the value for the last year as goal and a measure which calculate the value for this year as indicator.
The visual shows the actual reached value (big and green) thereunder at the left hand the goal and value and on the right hand the reached progression as percentage.
I hope that will help you.
on 10-24-2016 12:26 AM
Thanks. Yes I know what the KPI visual does. But my question what when does it turn green, amber or red. At what %age levels of reaching the goal does it become these colours? Is it always red until it reaches goal metric? I would have though it would be something like if its 80% of goal it would be amber and below that it would be red and so on.
If not, how does one set it to be that?
on 10-25-2016 04:59 PM
To customize the conditional behaviour on KPI visual, please follow the below steps
1> Two measures required
DAMP% (value to be shown on KPI visual) formatted to percentage
Create a new measure with target value, say Target=1 (or as per your targets say 0.9 (means 90%)or 0.8 (means 80%)
2> use KPIstatuswithhistory (available in visual gallery)
3> In the fields section,
Actual Value = DAMP%
Target Value = Target
4> In the format section,
Banding = .5
Now, see the visual behaviour
if DAMP% = 100% then visual will be Green
If DAMP% > 99.6% then visual will be Amber
if DAMP% <=99.5% then visual will be red
To control the KPI to turn amber, edit the banding to desired value.