Display Non time-series graph

I have the following data table

id category_id name
1 1 Name1
2 1 Name2
3 2 Name3
4 2 Name4
5 1 Name5

I want to display a bar graph with the category_id on x-axis and count of usage on y-axis

category_id usage
1 3
2 2

How can I display a non-time-series graph?

this is not possible

Write correct query, example:

SELECT category_id, COUNT(*) AS usage
FROM table 
GROUP BY category_id

and configure X-AxisMode: Series:

Don’t expect the best UI experience (e.g. label rotation), because Grafana is designed for time series data.