How to return empty tables like aggregation function?

Hi @Anaisdg ,

 I know that selector functions drop empty tables by design.

 If we want to do this, how could we do ?
 |> aggregateWindow(every: 1d, fn: max, createEmpty: true)  
 |> fill(column: "_value", usePrevious: true)

Hello @Erikson,
Can you please be a little bit more specific?
That query works just find for me.

Do you mean return empty tables with just a max() function?
Could you please describe some dummy input data and your expected output? Thank you!

from(bucket: “mytest”)
|> range(start: 2022-09-01T16:00:00Z, stop: 2022-09-05T16:00:00Z)
|> filter(fn: (r) => r[“_measurement”] == “TestSensor”)
|> filter(fn: (r) => r[“Addr”] == “AF2D”)
|> filter(fn: (r) => r[“_field”] == “temp”)
|> toFloat()
|> timeShift(duration: 8h)
|> aggregateWindow(every: 1d, fn: mean, createEmpty: true)

,result,table,Addr,_field,_measurement,_start,_stop,_value,_time
,0,AF2D,temp,TestSensor,2022-09-02T00:00:00Z,2022-09-06T00:00:00Z,24.414556962025312,2022-09-03T00:00:00Z
,0,AF2D,temp,TestSensor,2022-09-02T00:00:00Z,2022-09-06T00:00:00Z,2022-09-04T00:00:00Z
,0,AF2D,temp,TestSensor,2022-09-02T00:00:00Z,2022-09-06T00:00:00Z,2022-09-05T00:00:00Z
,0,AF2D,temp,TestSensor,2022-09-02T00:00:00Z,2022-09-06T00:00:00Z,24.600000000000005,2022-09-06T00:00:00Z

from(bucket: “mytest”)
|> range(start: 2022-09-01T16:00:00Z, stop: 2022-09-05T16:00:00Z)
|> filter(fn: (r) => r[“_measurement”] == “TestSensor”)
|> filter(fn: (r) => r[“Addr”] == “AF2D”)
|> filter(fn: (r) => r[“_field”] == “temp”)
|> toFloat()
|> timeShift(duration: 8h)
|> aggregateWindow(every: 1d, fn: max, createEmpty: true)

,result,table,Addr,_field,_measurement,_start,_stop,_time,_value
,0,AF2D,temp,TestSensor,2022-09-02T00:00:00Z,2022-09-06T00:00:00Z,2022-09-03T00:00:00Z,24.9
,0,AF2D,temp,TestSensor,2022-09-02T00:00:00Z,2022-09-06T00:00:00Z,2022-09-06T00:00:00Z,24.9

We lost some data and expect empty tables like aggregation function : mean