1 of 1 people found this helpful
Create a parallel calc.
If [original time] >= 6:00 then subtract 6 hours
add 18 hours.
Sort on that field, but display your original time.
sorry, I don't understand. I tried to do this, but the calculation contains error
please, Can you explain again?
Here with an explanation...
You start with a date & time column
First we need the hour part... DATEPART('hour',[Datetime])
You can hopefully see we have a 2nd column now called hour.
Now to Joe's calculation - create a new calculated field
IF [hour] >= 6 THEN [hour]-6
What that is doing... it is creating a new fake time, where 6am is really 0, 7am is 1 etc.
You will need to swap it to dimension - discrete (so it turns blue)
The trick is to put this field on the left hand side and sort in ascending order, you can then hide it (right click untick show header)
Now everything is sorted so 6am is first and 5am is last
V9.3.5 copy attached - created in Regional workbook - Weather data source (needed the time )
Hope that helps, please mark Joe's answer as correct.
212433.twbx 60.4 KB
I did it! it is really useful
Thank you so much,