Issue with time series when using SQL query and filtering by date

[kanishk]

I have used time grouping to display the data by months, but when I filter for a specific date, the month changes to first day of the month.

For eg when I filter for Aug 27 to Sept 2nd, the x-axis switches for Aug 2025 to August 1, 2025.

Is it possible to retain the month when filtering by date? (Scale is set to Timeseries already).

Without filter by date:

With date filter:

[TonyC]

What version are you running?

[kanishk]

I am using version 0.56.3

You have to Time group it by ‘month’ first, and apply a filter for a specific date within the same month. You will see the 1st of that month pop up in the chart, instead of the month itself.

[TonyC]

Like this? Can you share proper replication steps