We do business intelligence and a central part of our work is reporting on KPIs. For the sake of clarity, we define a KPI as an Actual, Target(s), and Comparison Method. There are usually two Values and an Indicator, like a traffic light, or an arrow pointing in different directions. Sometimes, there's a Gauge as well.
For example, higher is good, the target is a fixed value. There's also lower is good, going up is good, going down is good, and Goldilocks. For the Goldilocks comparison method (not too hot, not too cold) we specify a range, and staying in the range is good.
For the life of me, I've studied the documentation, and I can't find a KPI Indicator control. What am I missing?
Cheers, Donna Kelly.
p.s. if you ever use SQL Server Analysis Services Cubes, these are actually built in to the Cube, and feed SQL Server Reporting Services KPIs directly. This link shows the kind of thing I'm looking for.