Populating missing data for dates where product has no volume
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?