I’m using Grafana 8.3.4 and I am trying to solve following problem:
In a dashboard I have several Stat panels.
In each Stat panel, I have three queries from an InfluxDB.
The first two queries return a time series with values of 0 or 1, for the closed or open state of windows each.
The third queriy returns a time series with values of 0 or 1 for an alarm.
While the first two queries return the state of two separate windows, I would like to summarize the state in a transformation, which I have done.
I have used the transformation “Reduce row” with the first two queries, so the transformation returns a time series with values 0 (for no window open), 1 (for one window open) or 2 (for two windows open).
So far, so good.
Now I see four rows in the Stat panel. But I would like to see only two: the summarized window status and the alarm.
How can I do that? If I chose “Replace all fields” on the transformation, only the transformation is shown, but not the third query.
Is there any possibility to select which query and which transformation are shown in the panel?
And if so, can I arrange the selected items in a certain order?
I hope that I have described my question well enough?
Thank you very much in advance and best regards,