Grafana version: 7.4.5
I need to create a pie chart with every location (metric) and the number of cars in it (value).
The query is:
select last(“locality”) as locality from locations group by “car_id”
It’s not possible to group by “locality” because it is a field, not a tag.
I’m using a “Group by” transform to group by locality with these options;
locality → group
car_id → count
and results are ok in a table panel:
New York 32
but there is no way to show it as a pie chart or a bar graph.
Any ideas?. Thanks in advance.