Hello, I am having trouble with a bar graph. I suspect what I want do is just a feature that doesn’t yet exist, but I wanted the community to verify that before I made a feature request. I have a bar graph that has a lot of bars. It seems that the only option is to display them all at once, which scales them very small (essentially it’s zoomed all the way out). Also, all their labels lay on top of one another, making them unreadable.
Is there any way to zoom into a bar graph? If so, could one then scroll the graph horizontally? I know the traditional way to zoom and scroll a panel would be to simply change the time interval, but that doesn’t do much for table data, which is what I am displaying.
If I only had one bar per label, I could just use a bar gauge. When positioned horizontally a bar gauge scales well enough and allows for scrolling. Also, by virtue of it being horizontal, the labels don’t lay on each other.
Am I missing something, or is grafana missing this functionality?
- **What Grafana version and what operating system are you using?
The latest docker container. - What are you trying to achieve?
A readable bar graph with a lot of data. - How are you trying to achieve it?
The existing bar graph panel. - What happened?
The panel attempts to display all data at once, becoming unreadable due to scaling. The labels lay over each other. - What did you expect to happen?
I had hoped there would be an option to scale the graph myself, or at least to zoom in and scroll. - Can you copy/paste the configuration(s) that you are having problems with?
Query (Postgresql):
SELECT
identifier,
min(metric) as “Min”,
percentile_cont(0.25) within group(order by metric) as “Q1”,
avg(metric) as “Avg”,
percentile_cont(0.75) within group(order by metric) as “Q3”,
max(metric) as “Max”
FROM database
WHERE
EXTRACT(EPOCH FROM (time_and_date)) BETWEEN ${__from:date:seconds} AND ${__to:date:seconds}
AND identifier IS NOT NULL
AND metric > 45
AND other_identifier LIKE ‘SPECIFIC-STRING’
GROUP BY identifier
ORDER BY “Avg” desc
Panel settings are default.
- Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
No - Did you follow any online instructions? If so, what is the URL?
No