5 Replies Latest reply on May 23, 2014 9:53 AM by Brandon Avants

    Number of Open Cases

    Brandon Avants

      I'm trying to recreate the viz below but I don't have the data in this way.

      Open.PNG

       

      I have created time and due by time.  So, that being said I did the following......

       

      = Days Past Due

      DATEDIFF('day',[DueBy Time],TODAY()  )

       

      = On time KPI

      IF ([Days Past Due] > 0) THEN 'Late'

      else 'On Track'

      END

       

      I have come up with this which is wrong by using the above formulas but it's close.

      Wrong.PNG

       

      How can I roll up all the open cases through Jan into the January tab, same for Feb if they are still open, etc?

       

      I added a made up workbook Message was edited by: Brandon Avants