4 Replies Latest reply: Jun 11, 2015 2:46 PM by Kevin Xu RSS

    How to "filter" a KPI?

      Hey guys,

       

      I am creating a KPI's of safety priority (High, Medium, Low). I have a dimension called "Priority" that lists the priority (High, Medium, Low) for each safety case. Unfortunately when creating the KPI, sum(Priority) counts all of them whereas I would like to be able to just list the number of each (Ex: Number of "High" priority cases).

       

      Is there an if statement or something I can use? Thanks for your help.