I am using the Azure Monitor data source to query Log Analytics. In the query, I am summarizing and simultaneously calculating the average and maximum.
| summarize Avg = avg(Value), Max = max(Value) by bin(TimeGenerated, interval)
According to the documentation, the format as ‘Time series’ would not work because it “returns the first column with a numeric datatype as the value”. So I have selected the format as ‘Table’.
Can I even use the format as ‘Table’ with the graph panel?
I’ve been looking at and trying the series override but it doesn’t pick up the data.