I have a data in the following format.
Postal CodeStateTimeDayRoad TypeNumber of Accidents10003NYDSundayUrban2010021NYBMondaySemi urban3410041NYDTuesdayRural1510113NYCWednesdayUrban4810150NYDThursdaySemi urban9910160NYEFridayRural14610152NYDSaturdayUrban20110162NYASundaySemi urban410154NYAMondayRural610164NYATuesdayUrban7
My Question is how to display the time in the following format.
When "A" then [6AM-9:59AM]
When "B" then [10AM-3:39PM]
when "C" then [4PM-7:59PM]
when "D" then [8PM-11:59PM]
When "E" then [12AM-5:59AM]
In the sense the filter drop down should have
[6AM-9:59AM]
[10AM-3:39PM]
[4PM-7:59PM]
[8PM-11:59PM]
[12AM-5:59AM]
Solutions please....
7 answers
You could do a CASE Statement:
CASE [Time]
When "A" then "[6AM-9:59AM]"
When "B" then "[10AM-3:39PM]"
when "C" then "[4PM-7:59PM]"
when "D" then "[8PM-11:59PM]"
When "E" then "[12AM-5:59AM]"
END
Drag it to filter and select show filter.
