Can't group by month/date after converting time zone

Hi there,

I have a graph currently grouping sales by month, the time however from our database is in UTC.

I can convert this to Australia/Melbourne perfectly fine via a custom column but I then can't use that custom column with the correct timezone to group the sales by month, week, year etc.

When using a custom column, Metabse no longer lets me select what period of time to summarize by date.

Is there a way to fix this?

Thanks