Calculate Average and Standard Deviation with missing dates in time series
When calculating the average usage and standard deviation for a list of parts based over a time series the results are not what is expected. The problem is not having a complete list of dates for each part number. I would need to generate the missing dates for each item number with a value of zero for the equations to work correctly. See attachment for better explanation. I am unsure of how to accomplish this in Domo.