Forum Discussion
PowerKPI Matrix Sparkline
Many thanks for taking the time to reply. I have found a way to do what I want.
In my dashboard I have some KPIs where the "actual value" below a target is good e.g. we want fewer complaints than our target. And some where "actual value" above target is good. e.g. sales. In the KPI Matrix sample file the variance from target is calucated and a RAG status given depending on the parameters you set. I didn't know if there was something built into the template that indicated whether, for individual KPIs, above or below target should be Red/Green. And I still don't know that. But what I did was added a column which indicated the "direction" of the target. I just labelled each KPI as either Low or High. And then when it is Low I'm multiplying the variance by -1. That works so that my RAG status labels are all correct.
Many thanks for taking the time to reply. I have found a way to do what I want.
In my dashboard I have some KPIs where the "actual value" below a target is good e.g. we want fewer complaints than our target. And some where "actual value" above target is good. e.g. sales. In the KPI Matrix sample file the variance from target is calucated and a RAG status given depending on the parameters you set. I didn't know if there was something built into the template that indicated whether, for individual KPIs, above or below target should be Red/Green. And I still don't know that. But what I did was added a column which indicated the "direction" of the target. I just labelled each KPI as either Low or High. And then when it is Low I'm multiplying the variance by -1. That works so that my RAG status labels are all correct.
That's a clever solution. I never thought of that. Thank you for enlightening me.