I have a report which shows the financial transactions total for users in the database. Currently, when a single day is selected on the calendar, this shows users total transactions for the 24hr period of that selected day (from Midnight to Midnight).
Is it possible to offset the 'day' of this report so that the 24hr period being shown is actually 3am to 3am?
I would like to achieve this without affecting other reports. In other words, I want to keep the current setting (Midnight to Midnight) for all other existing reports, but only change the setting for this one report (3am to 3am),