Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Shift wise Date time and grouping

 

Hello ,
I have date and time data using i want to calcualate Shift

Shift A: 6AM to 2PM
Shift B: 2PM to 10PM
Shift C: 10PM to 6AM

how i calculate last shipt becouse that is in next 4 hr

 

 

Regards ,
pooja

 

General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    8 years ago

    HI Anonymous,

     

    I'd like to suggest you add calculated column to marking tag. Then you only need to calculate out nearest time to find out the correspond ship.

    Category = 
VAR hour =
    HOUR ( [Time] )
RETURN
  "Shift "&  IF ( hour >= 6 && hour < 14, "A", IF ( hour >= 14 && hour < 22, "B", "C" ) )

     

    Regards,

    Xiaoxin Sheng

7 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    HI Anonymous,

     

    I'd like to suggest you add calculated column to marking tag. Then you only need to calculate out nearest time to find out the correspond ship.

    Category = 
VAR hour =
    HOUR ( [Time] )
RETURN
  "Shift "&  IF ( hour >= 6 && hour < 14, "A", IF ( hour >= 14 && hour < 22, "B", "C" ) )

     

    Regards,

    Xiaoxin Sheng

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi Xiaoxin Sheng and comunity, I have tried this:

      Category = 
VAR hour =
    HOUR ( [Time] )
RETURN
  "Shift "&  IF ( hour >= 6 && hour < 14, "A", IF ( hour >= 14 && hour < 22, "B", "C" ) )

      but it did not work. Any advice?

      Thx a lot.

      Karol

  • jhaldane's avatar
    jhaldane
    Frequent Visitor
    8 years ago

    Hi

    Please can you support me from scratch with a similar query below.

    1. How do i separate date and time and then

    2. How do i create Shifts. Shift 1 06:00 - 14:00, Shift 2 14:00 - 22:00 and Shift 3 22:00 - 06:00

    Would really apprecite your support

    Thanks

    Jerry

     

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hello @jhaldane,
      Seperate date and time Using split option is available.
      and then no need of date on only using time you can write conditions like

      Category = 
VAR hour =
    HOUR ( [Time] )
RETURN
  "Shift "&  IF ( hour >= 6 && hour < 14, "A", IF ( hour >= 14 && hour < 22, "B", "C" ) )

      its may help
      Regard ,
      pooja