Mathematical operators with wildcards and regular expressions - Watt to Wh

Fluxlang
1

Hello,
I’m quite new using influxdb and SQL like language in general.
I am collecting some power measurements from some zigbee smart plugs and NodeRed stores them in influx.
Now I would like “convert” those measures in watt to Kwh.
First of all I thought to use mean function to calculate the mean of the measures grouping them by a specific interval:

> select mean(*) from power.autogen.frigorifero where time> now()-24h group by time(1h) fill(0)

name: frigorifero

-----------------

time mean_value

1553709600000000000 149.50197628458497

1553713200000000000 30.153361344537814

1553716800000000000 143.65522388059702

1553720400000000000 120.80924287118977

1553724000000000000 128.0880149812734

1553727600000000000 70.65906210392902

1553731200000000000 118.14522821576763

1553734800000000000 92.06942392909896

1553738400000000000 41.93884892086331

1553742000000000000 107.48995363214837

1553745600000000000 8.712121212121213

1553749200000000000 117.536

1553752800000000000 63.27383367139959

1553756400000000000 126.72920696324951

1553760000000000000 243.04273504273505

1553763600000000000 144.0154711673699

1553767200000000000 43.862385321100916

1553770800000000000 116.73634945397816

1553774400000000000 8.378787878787879

1553778000000000000 135.23595505617976

1553781600000000000 58.214920071047956

1553785200000000000 114.91379310344827

1553788800000000000 69.89889196675901

1553792400000000000 86.96193771626298

1553796000000000000 0.9857142857142858

Now I should multiply each value for a time period and then sum all those values but as I read in the Influx common issues I cannot do something like:

select mean(*) * 1 from power.autogen.frigorifero where time> now()-24h group by time(1h) fill(0)

Is there any smart way to convert my measures from W to Wh?

Thank You

Regards

2

@mauog try this

SELECT mean("power") * 5 FROM (SELECT "your_tag", "your_field" AS "power" FROM power.autogen.frigorifero WHERE time > now() - 24h GROUP BY time(1h) fill(0))