Gap-filling at the beginning of a TIMESERIES
Hi, I'm trying to generate some aggregate numbers grouped by date using the TIMESERIES clause to provide gap-filling. The gap-filling works, so long as data exists on the first and last day, but if it doesn't, the data will only start on the first day containing data. For example, consider the following query: SELECT slice_time FROM data_table WHERE data_date BETWEEN '2013-06-01' AND '2013-06-10' TIMESERIES slice_time AS '1 DAY' OVER (ORDER BY data_date); If there are no rows with data_date from '2013-06-01' to '2013-06-04' then the TIMESERIES will not be gap-filled for those dates. What can I do?
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.