Bar graph from momentarily Watt-Values

[ionfan]

Hello Community,
i have a problem creating a Visualization where my Power-Values from Smartmeter (in W) are visualized as Bar Graphs for every Day/Month/year.
I’m only storing the momentarily Values in the InfluxDB. I can also store the meter count in the db, but for that i don’t have that year of data history stored. So it would be better if i can do the calculation directly in grafana.
I already figured out that i have to do the integral over the values and then do a math with divide by 3600 to get to Wh.
But i did not get how to choose the time over which this is calculated. In the time field the max i can choose is 1h.
And how can i make this selectable what time aggregation i want (day/month/year)?
Can anyone help me out with this?
Regards
ionfan

[ionfan]

Has no one an idea? Is my question unclear? Please ask if i wrote my explanation not clear.
Regards
ionfan

[danielgonzalez]

What frecuency are you using for capturing the data??
Maybe you can get some ideas from here

Properly Displaying Power Consumption from kW to kWh

Hi, Wanted to first off say Thanks to all who put in work to make Grafana happen, what an amazing tool. Eternally grateful. I’m trying to create a dashboard that shows the total power used in kWh. I have the kW demand, as the equipment draws power over time, I see the energy used, but it is not calculated. I’ve searched and found a few power dashboards, but I tried them as well and can’t get it to work. I’ve tried few things and can’t figure this out. I’m running Grafana 5.0 and influxDB. [0…

[rothestar]

This is from a PV plant, and the input is in watts, if your input is in kW you just have to change the select statements to: SELECT Field(PVpower) intergral() math(/3600)

Hope that helps…

Best regards
Rothestar