I’d like to build a graph using the min, max, and average values for a dataset I have with per-minute values grouped into hourly buckets. I’m envisioning something like the example screenshot from this Grafana documentation. I think I should be able to use Grafana transforms to calculate the hourly min, max, and average values. I see how to get a min or max per hour. But I don’t see a way to get multiple transformed output from 1 series.
The alternatives I can think of are to rerun the query for each of min, max, average, which is quite expensive, or use another panel as the source, (but you can’t hide panels so then I’d have that hanging out).
Is there an elegant way to do this?