Showing Average per day (database last 90 days)

Hello Community,
I just started with Grafana and it is overwhelming. So many options and things to display. puh.

I want an average value for my power consumption. I got it for the 24h. It shows the energy consumtion for the last 24h. Great.

I’m trying to get the average value per day but calculated with the data of the last week, 30 and 90 days.
Unfortunately, if I select i.e. last week, it shows me the consumption of the last week in total. I would like the week value divided by 7. For the 30 days deviced by 30 and 90 days obviously devided by 90. Does grafana provide this possibility.

okay just figured it out.

Hi @querys1,

Welcome to the :grafana: community support forums !!

We are excited that you joined our OSS community. Please read about some of the FAQs in the community :slight_smile:

It is good to hear that you figured out the solution :+1:

We would appreciate if you can also share your solution with the community so that it become helpful for the Open source community.


In the end it was easier as I thought. You it is nessesary to use the Transform function. “Add field from calculation” → binary operation and devide the entity by a value you like.

1 Like