4 Replies Latest reply: Jun 2, 2017 10:49 AM by Vijayanth Radha RSS

    Help with KPI

    Vijayanth Radha

      I have a dimension called "Priority" with three possible values:

      CatA

      CatB

      CatC

       

      1. I have a table with dimension Priority and count of it as a measure

       

      2. Then we also have three KPIs: like shown below:

       

      count({$<[Priority] = {CatA}>} distinct CASE_ID_INT)

       

      count({$<[Priority] = {CatB}>} distinct CASE_ID_INT)

       

      count({$<[Priority] = {CatC}>} distinct CASE_ID_INT)

       

      Question:

       

      If I select Priority CatB in table, I expect the first and third KPIs to become Zero. buts not. What am I doing incorrectly?