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 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 change.
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)