How to plot only maximum per day?

Hello everyone,

I am using Grafana in Home Assistant together with InfluxDB.

I have energy consumption data and I would like to create a graph that shows the daily maximum value of each day of the last 14 days.

I have everything working except getting Grafana to display only one datapoint per calendar day (the maximum value).
How can I achieve this?

Basically “show only maximum value between 00:00 and 24:00 o’clock”.

Thank you for your help! :slight_smile:


Hi @alexsr700,

Care to share your query? Check out this thread for a good place to start:

Once you’ve grouped the data into 24 hour periods, you can further tweak the query to select the max value. You could also probably use the standard field options in Grafana’s panel editor to select the max value at that stage as well.

This topic was automatically closed after 365 days. New replies are no longer allowed.