Calculate daily power/coast consumption

Hello, thank you for your response.

The measurement and unit written to influxdb are watts in current use, the value refresh by itself regularly.

The value i’m getting from my current watts usage in influxdb are true and they are the same in the offical app from my power switch.

I would like to group this values to display the power usage per day with ‘bars’.

Unfortunatly i don’t understand how to group the watts power usage per days, has shown on the above pictures when i had the ‘1 day group by interval’ the values i’m getting are wrong.

Thanks.