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.



      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'



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



      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