Cannot get uniform time axis for logs volume

[adamarczynski]

Hi all,

I am learning Grafana and I am struggling to get a proper log volume graph. When I pick explore view it looks nice. I can see all logs and a volume graph showing periods when I ran load tests and when the app was idling.

However, when I add it to a dashboard, only logs are added without this graph. I am trying to recreate it with a bar chart
sum by(level) (count_over_time({app="Company App"} |= $searchText [$__auto]))
but the x-axis with time looks very odd. Periods when the app was idling are gone and it shows only moments when the app was logging anything. For example, the period between 13:50 and 14:14 is missing. It does not show the selected time window of last 3 hours uniformly. How to get the same graph as in the Explore View?

Many thanks,
Adam

[tonyswumac]

1. Try to create a new graph panel and see if it does anything differently.

2. Check the returned data in a table view (specifically see if you can see the gap still).

[adamarczynski]

Thank you for the hints. I have tried creating a new graph panel several times but it does not help. The gap is also visible in the Graph view. Some fresh data:

2024-01-03 10:11:06 40
2024-01-03 10:11:08 40
2024-01-03 10:23:50 2
2024-01-03 10:23:52 40
2024-01-03 10:23:54 40

When the app is idling, there are no logs and no data in Grafana which sounds logical. I am struggling, however, with forcing the graph to fill the time axis with periods without data. I suppose it is possible as it is what happens in the explore view — no idea how to achieve it in the dashboard view, though.