Displaying Solar Energy Production in Grafana

Hello everyone! I’ve been diving into the world of home automation and energy monitoring, and I’m thrilled to share my recent success with Grafana and InfluxDB. After following Simon’s excellent tutorial, I managed to set up a beautiful dashboard to visualize my solar energy production. It’s incredibly satisfying to see all that data come together in such a clean and informative way!

However, I’ve hit a small snag that I’m hoping the community can help me with. While I can display the current production in real-time, I’m struggling to get a cumulative sum over a selected time period. I tried using the sum() function, but it doesn’t seem to work as expected. I’ve attached a couple of screenshots to show what I’m aiming for and where I’m stuck.

grafana1

grafana2

If anyone has tackled this before or has some insight into the right parameters or functions to use, I’d be incredibly grateful! It would be amazing to have that total sum to better understand my energy production trends. Thanks in advance for your help and insights!

Cheers,
Elmar