I was modifying a Stat panel and noticed that its JSON resultFormat key parameter was set to table.
That configuration caused my query to return an actual data table, but I was looking for a time_series format.
I searched and searched for a configuration option to change such a parameter, but could not find any in the panel interface.
I’m not sure why the parameter was set to table.
Where can I configure the resultFormat key besides editing the panel JSON?
Usually you can change that option in query builder of your query:
I could not find such option in my query.
May be it has no effect for your particular datasource (you didn’t mention which one you are using, is that zabbix)?
What is the effect of that key on your Stat panel?
If it is needed you may open an issue here:
Yes, it is a Zabbix data-source. Sorry for that.
Zabbix 7.0
Grafana 11.0.0 / Grafana Cloud
First, my goal was to query multiple items using a regular expression on the “item” field. Then I would create secondary panels using the “Dashboard” data-source and source the first panel query, as shown in my previous post.
The issue is that when the query result format is set to table, what I end up with is a list of “host”, “item”, “key” and “last value”.
Only when I switch to time_series, does it actually return the queried item series, which I can then filter with “Transform data”.
So, you think that the missing Format as option might be a bug?
Might be.
Could you reproduce the same behaviour here?
I didn’t know about this Grafana Zabbix playground. It’s pretty cool.
However, when I create a new Stat panel on it, there is no Format as option available, just like in my own environment.
I can see the JSON resultFormat key in the query inspector, but there’s no Format as option.
I’m not sure where you found this option.
