Forum Discussion
Solved
Select 4 highest values at different Intervals
Hi , I have a requirement which asks me to select 4 highest time between the time interval of 7AM to 10 PM based on the water usage. Currently,it selects the 4 highest between these time ,But, It h...
Learner_SG , Create a column like
=
Var _time = timevalue([Datime])
return
Switch(True() ,
_time >= Time(7,0,0) && _time < Time(12,0,0) , "7AM-11 AM" ,
_time >= Time(12,0,0) && _time < Time(15,0,0) , "12 PM-2 PM" ,
_time >= Time(15,0,0) && _time < Time(19,0,0) , "3-6PM " ,
_time >= Time(19,0,0) && _time < Time(23,0,0) , "7PM-10PM" )
Learner_SG , Create a column like
=
Var _time = timevalue([Datime])
return
Switch(True() ,
_time >= Time(7,0,0) && _time < Time(12,0,0) , "7AM-11 AM" ,
_time >= Time(12,0,0) && _time < Time(15,0,0) , "12 PM-2 PM" ,
_time >= Time(15,0,0) && _time < Time(19,0,0) , "3-6PM " ,
_time >= Time(19,0,0) && _time < Time(23,0,0) , "7PM-10PM" )