Hello, i’m new on grafana and i trying to represent data into graph without date.
I just want to represent number of episodes grouped by collection name as you can see in the query. i dont care about date there, is there any way to do it? i tryed but i dont understand it.
DataSource: Postgres 10
SELECT collection_collection.name AS name, Count(collection_episode.collection_id) AS metric FROM collection_collection INNER JOIN collection_episode ON collection_episode.collection_id=collection_collection.id GROUP BY collection_collection.name;
Error: No field name specified to use for x-axis, check your axes settings.
I checked that query inspector works and i tryed to change X-axes mode to select field but it didnt select.