1 Reply Latest reply on Sep 15, 2016 9:18 AM by Joe Oppelt

    Multiple Metrics in One Dimension - Applying Different Benchmarks

    Caleb King

      Hello,

       

      I am creating a KPI dashboard but am running into difficulties because my various metric descriptions are in one dimension and the corresponding metric values are also in a single respective dimension. How do I apply different benchmarks (bad, good, best) and stoplight colors to the various metrics? I would also like to insert a dynamic reference line at the minimum good value. I understand how to add one set of benchmarks to the entire dimension but not how to choose a set of benchmarks based on the metric description.

       

      I have attached a workbook for your reference. Any help would be much appreciated.