Start Hour of Sale at # instead of 1

[raisakarim]

Hello! New to using SAP BusinessObjects Web Intelligence for my business, so I apologize in advance if this is rudimentary question.

We are using the Hour of Sale characteristic in our ecomm reporting. However, the column starts with hour 1, which is 1am to 2am which is not actually the first hour of the day. The # hour is 12am to 1am, but it is the last column.

Is there a way to have the Hour of Sale start with #, then 1, 2 and so on? Instead of starting with 1?

SAP BusinessObjects - Web Intelligence (WebI) 

[nscheaffer · Accepted solution]

You could create a variable something like...

=If [Hour of Sale] = "12am" Then 0
ElseIf [Hour of Sale] = "1am" Then 1
...
ElseIf [Hour of Sale = "10pm" Then 22
Else 23

and sort by that.

Or put a custom sort on your [Hour of Sale] column.

[raisakarim · Accepted solution]

Thank you SO much! The custom sort video was exactly what I needed and worked perfectly!