5 Replies Latest reply: Mar 24, 2016 2:53 PM by Sunny Talwar RSS

    Why won't my KPI's update when filtered?



      I'm trying to create a KPI for Pending Apps, Completed Apps, and Denied Apps.  The Dimension is Application Status.


      Below is the syntax I'm using to COUNT all Pending Apps.

      Count({$<[Application Status]={'Pending'}>} DISTINCT [Application ID])


      Everything works correctly to get the COUNT; however, when I use the Application Status filter on my dashboard to filter out Pending Apps, the Count does not change to 0.  The other charts on the dashboard update, but these individual KPI's do not.


      Why is this happening?


      Thank you in advance for the help!