I want to create a summary table that has 2 columns - the first column would be the name of the data, and the second would be the value. These values would be the min / max / average of various metrics over a given time period.
Or, if this can't be done, maybe 4 columns
- the first column to be the name of the metric,
- the second to be min,
- the third average,
- fourth max.
Whenever I try to do this I get a separate column for each calculation, which leads to a table with a lot of blanks in it. Any way to do this?
Since you are using the same metric, you should include all the tags in the filter for the same query.
In your case, you should create the following queries, using the same formula, just replacing the aggregation you need.
I see the problem now. With no 'split by' condition, you still get the one line per query... So I think this can be an Idea candidate...