INJECT
Injects last value records in for a date range when the values are not present for that date.
For example, if a sensor emits data point 100 for 01/01/2016 and the next change of value is at 200 10 days later, you can use the inject function to inject 100 into all dates in between that range.
INJECT(<date field>, < start date range>, < enddate range>, < date frequency to inject>, [, <grouping field(s)>])
select inject(date, start_range_date, end_range_date, 1d, Name, Division)