1 Reply Latest reply on Jul 14, 2018 8:50 AM by Yuriy Fal

    Combine multiple calculated measures into a dimension

    Maddy Peña
    Maddy Peña Jul 12, 2018 10:17 AM

      Hello all!

      I have a database that consist in multiple "metrics" that when combined, result in multiple (about 17) KPI that my users need to see. After generating those KPIs, is it possible to combine them on a single dimension so I can use them as filter and on a table?

       

      I cannot pivot in the datasource because the KPIs don't exists at that level, only metrics and I cannot calculate them at DB level because they depend of the selected period of time. I can create a parameter that shows the KPIs but the problem is that I cannot select multiple values to show them all at once in a table. In addition to that, I need the Actual, Budget and delta measures for each KPI, so I had to create a calculated field with CASE to use the parameter. And some KPIs can only be calculated at plant level, and others at site level.

       

      I need to achieve something like this:

       

       

      Thanks!

        • 1. Re: Combine multiple calculated measures into a dimension
          Yuriy Fal
          Yuriy Fal Ambassador Jul 14, 2018 8:50 AM (in response to Maddy Peña)

          Hi Maddy,

           

          Obviously, you could approach the problem

          (of extending your 'table' layout) via a brute force --

          by duplicating the view and their respective  [KPI Level] Parameter,

          then combining as many such views as needed side-by-side on a dash.

           

          Users would be choosing the [KPI Level] for each vertical section

          via its own distinct Parameter.

           

          Of course, make the number of Rows manageable --

          to avoid vertical scrolling on a dashboard. Use common Filters.

           

          Frankly, i'm not aware of any suitable (less complicated) alternative layout.

           

          Yours,

          Yuri