Offset the 24 hour period of a daily report

[#1]

Hi,

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),

Any help would be greatly appreciated.

Thanks,

Peter

[swuehl]

Peter,

you could add an additional field to filter your timestamps accordingly, using daystart with additional shift parameter:

LOAD

..

TransactionTimestamp,

Date(daystart (TransactionTimestamp, 0, 0.125),'YYYY-MM-DD') as CustomWorkingDay,

...

from TransactionTable;

Or use similar in your chart expressions.

[#3]

Thanks for the suggestion.

I'll try it out and let you know.

[#4]

Hi swuehl,

That worked perfectly. I was able to create another calendar day selector in my document which shifted the day by three hours.

Thanks you very much.

Peter

[#5]

hi Swuehl,

I have similar problem and I need Hrs from 06 to 05.

Can you help me. My code and example is in this thread.

http://community.qlik.com/message/305015#305015