Getting hour from Time Stamp

[reshmakala]

Hello all,

I have an application with the order details. I want to show a drill down with Year, Month, Weekday and time of the day.

Year, month and Weekday was easy but when I try to extract hour from the order creation date, I get multiple records for same value.

I need something like below:

For 2016 -> Jan -> Tue -> between 00-01 there are 35332 orders placed.

Attached are the sample qvw and excel sheet. Please help me with this,

[swuehl · Accepted solution]

Use

Hour([CREATED TIMESTAMP]) as Hour

[Anonymous]

see the attached app

[reshmakala]

Thank you so much. That was pretty straight forward.