5 Replies Latest reply: Jul 15, 2014 7:35 PM by Nick Listerman RSS

    Populating missing data for dates where product has no volume

    Nick Listerman

      I'm trying to populate missing data in order to accurately calculate average and standard deviation for products over a given timeframe.

       

      I have a master calendar populating Opened_At_Date for the last 60 days and then I have an SQL query that is pulling in the count of incidents created by product over the last 60 days by date (same format as Opened_At_Date).  My problem is not every product has volume on every day.  I need to find the dates where a product doesn't have volume and populate it with a zero.  Thoughts?