Forum Discussion

pattarom's avatar
pattarom
New Member
4 years ago
Solved

Filling a column following specific rules

Hi I have a table containing data in this form (simplified):   DateTime TimeSlot measure1 measure 2 2022-01-10 00:00:00   3 10 2022-01-10 01:00:00   232 11 2022-01-10 02:00:00...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    pattarom , You can create a new column like


    Switch(True() ,

    Weekday([datetime],2) >=6 || Timevalue([DateTime]) <= time(7,0,0) || (Timevalue([DateTime]) > time(19,0,0) ) , "Low"
    (Timevalue([DateTime]) > time(7,0,0) && Timevalue([DateTime]) <= time(8,0,0) ) || (Timevalue([DateTime]) > time(17,0,0) && Timevalue([DateTime]) <= time(19,0,0) ) , "Mid" ,
    "High")

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

pattarom , You can create a new column like


Switch(True() ,

Weekday([datetime],2) >=6 || Timevalue([DateTime]) <= time(7,0,0) || (Timevalue([DateTime]) > time(19,0,0) ) , "Low"
(Timevalue([DateTime]) > time(7,0,0) && Timevalue([DateTime]) <= time(8,0,0) ) || (Timevalue([DateTime]) > time(17,0,0) && Timevalue([DateTime]) <= time(19,0,0) ) , "Mid" ,
"High")