Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Dynamic KPI

HI All,   I am using a KPI to color green, red, orange from two fields which use dynamically changing data ie. the value changes. But when the value change the KPI displays the wrong color.   Des...
Need Help
MalS's avatar
MalS
Resolver III
9 years ago

This might be a silly question, but did you check the formatting of the KPI?

 

In the Color Coding section you can set the Direction - either 'low is good' or 'high is good'. Maybe you just have that around the wrong way?

 

  • MalS's avatar
    MalS
    Resolver III
    9 years ago

    Nevermind - I see that the goal value is blank on the KPI, so ignore my last post. 

     

    The KPI is using the most recent (based on the trend axis) value for the Indicator and the Target Goal. If you do a simple table with your Trend Axis field (ChannelClean), your Indicator field (CPC) and Target Goal field (Average of CPC) included, then scroll to the very bottom - what do you see? Is the Average of CPC value blank? If so, that is going to cause problems.

     

    Normally the Trend Axis is a list of dates from a calendar table. What is the ChannelClean field that you are using for the Trend Axis? Is it a list of dates, or something else?

     

    Regards,

     

    Mal