2 Replies Latest reply on Aug 26, 2013 11:01 AM by Austin Wagner

    Fill in Empty Date Values

    Austin Wagner

      I have a metric (applications started) that needs to be counted over months.  In other words, what % of our monthly applications get started by the 1st, 5th, 20th, etc of each month. 

       

      The problem lies when there are no applications started in a day, and that day doesn't show up.  I have tried the zn function and indexes unsuccessfully.  Does anyone know how I can fill in the missing dates?