How to force the x-axis frequency to 1 day

Grafana Time Series Panel
1

HI all, I’m querying a DB an grouping data by date.
I use the Graph panel to chart it.

Unfortunately the panel is setting the x-axis frequncy to 2 days… and I don’t know why… please see here:

.Snipaste_2020-01-08_18-11-29

On the x-axis I get a date every 2 days. But data granularity is 1 day.
how can I force the x-axis to display all days? Like 12/11, 12/12, 12/13, 12/14… and so on.

I’m getting crazy, thank for helping! :slight_smile:
Giuseppe

EDIT: This is the grouping I’m using

GROUP BY CAST([EndTime] AS DATE)

1 Like
2

Unfortunately, this is not supported, as the values for the X-axis are dynamically adjusted based on the current time range in Grafana.

However, if you change the Mode from Time to Series, you can accomplish something similar to the use case you’re mentioning