How to run backfill?

[melkati]

I can't get backfill to work. Any one can give me an example, please?

I have a very simple db called db_casa with some measurements like CO2Despacho with just timestamp and value.

In the Run backfill dialog I select CO2Despacho as source, CO2DespachoBF as destination, interval 1h, from and to times to cover all the DB and in "#edit your query / downsamplers here" i put "mean("value")".

When I run this I get in CO2DespachoBF values that are not the mean result for each hour.

[tihomir-kit]

Hi, could you share your backfill query?

[melkati]

I guess its where it says "#edit your query / downsamplers here". I tried with "mean("value")"

[melkati]

Any clue on how to run backfill? An example backfill query I can adapt should be great. I’m still stuck at this.

Thank you.