14 Replies Latest reply: Sep 23, 2016 10:46 AM by Josh Martyne RSS

    Measuring difference between Max week and previous in a KPI Widget

    Josh Martyne

      Hi All,

       

      I want to use a KPI widget to show Numbers of Incidents for the Max week, Then add an up down arrow or conditional limit to show how this changed from the week previously.

       

      I have tried to add a master calendar and from posts ive read I think that I need use use (Max(Date) and (Max(Date)-1) but haven't had any luck.

       

      Examples of the kind of expressions ive tried are below

       

      //Count(Incident)

      //Count( {$<Year = {$(#varMaxDate)}>} Incident )

      //=Count({<Month={$(=Max(Month)-1)}>} Incident )

      //Count({<Month={$(=Max(Month)-1)}>} Incident)

      //Count({<MonthName={"$(=Month(Max(Date)-1))"},Year={"$(=(Year))"}>}Incident)

      //Count({$<MonthYear={$(=Only(MonthYear)-1)}>}Incident)

      //Count({<Month = {$(MONTH =(MAX(Date))}>} Incident

      //Count({<Year = {$(MAX(Year))},Month = {'$(=MONTH(MAX(Date)))'}>}Incident)

       

      Any help would be much appreciated.

       

      QVF attached

       

      Thanks

       

      Josh