Day of Month Aggregation stop Working after Upgrading to 0.56

[kittim45]

Hi Metabase Community, we’ve upgraded to 0.56.3.3 (from 0.53.60).

However, after upgrading, the “Day of Month” bin aggregation is not working properly on Line graphs when display as Ordinal (i.e. 1,2,3… 31) .

We expected the graph from previous month to overlap with the current month by day of month.

Our backed database is Databricks and the column data type is Date. Currently, workaround using
day([Date Column]) custom expression works.

Let us know if you have any other solution or what did we do wrong on this chart.

[TonyC]

Interesting, I don’t seem to have similar behaviour (but I see you have Date Date: Day of Month)

Could you share the definition of the question? Maybe that’s where I am missing something:

[dwhitemv]

Did you try on DataBricks specifically? I can’t reproduce the problem on PostgreSQL. I’m guessing its a problem with the query translation.