Fill() function but for every column in table

i have a Table with 20 columns and every now and the there is a gap that needs to be filled with the previous value. At the moment i am using the fill function 20 times to fill every column. The Problem is that the Query Perfomance is to slow and i want to optimize it.

My Query looks like this:

from(bucket: “MyBucket”)

|> range(start: v.timeRangeStart, stop: v.timeRangeStop)

|> filter(fn: (r) =>

r._measurement == “MyMeasurement” and

r.short == “M1” or

r.short == “M2” or

r.short == “M3” or

r.short == “M4” or

(and so on up to M20)



|> pivot(


columnKey: ["short","_field"],

valueColumn: "_value"





(And so on up to M20)

Is there a way that i can use the fill() function or something similiar only once?

Hello @Patse,
I’m sorry to inform you that this is currently possible. However, if you’re interested in seeing this added to Flux, please comment on the issue below:

Hey thank you for your help.
To bad it doesn’t work.