Hoping for some help please, very new to using grafana.
My query output has 2 columns, one is an epoch timestamp and one a metric . On the dashboard panel it shows correctly as a graph. (pic1) When I run the same query in the alert environment, I get 2 columns and one row as the result, ‘Series 1’ and the (I assume last) epoch timestamp. (pic2)
When I remove mytime from the query and leave only the metric as the output I get a table like
Series 1 count1
Series 2 count2
Series 3 count 3
etc etc … (pic 3)
Why is this and how can I fix it please? Every tutorial I have watched/read says I need a time and metric column (not to be called ‘metric’) and in the tutorial videos I see a graph in the ‘preview code’
I am connecting to Doris.
I am trying to set up a threshold alert, can anyone please point out what I am doing so wrong?