Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
Use
Hour([CREATED TIMESTAMP]) as Hour
see the attached app
Thank you so much. That was pretty straight forward.