Dynamic time fields based on reporting time zone not database time zone

I would like to generate reports based on the report time zone, not the database time zone. Although we save all of our data in UTC, in reality, we care about in terms of the time zone offset. There, when we say “current week” or “current day,” we would like it to filter data based on “current day” in our reporting time zone, not the db time zone.

Currently, it seems to pull/group data based on db time zone, and then convert that data based on the reporting settings. This also explains why the data labels are off by one day in the charts. (Once a day is normalized to the time zone, it is the previous day in the reporting time zone)

Any suggestions?