To get the max/min/avg-value from a selected interval in Grafana when using MySQL as data storage just add the following expression to your SQL query:

<SQL-QUERY> WHERE $__timeFilter(<time-column>)

Replace <time-column> with the name of your column where the time data is stored.

After that navigate to Value options>Calculation and select MAX/MIN/AVG.

Sourced from - table queries and - min-max-values

  • monitoring/grafana.txt
  • Last modified: 2024/04/28 21:22
  • by Zyzonix