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.
Info:
DataSource: Postgres 10
query:
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.
Thank you