Forum Discussion

mrolly's avatar
mrolly
Regular Visitor
1 year ago
Solved

Help: Insert Shift into Data Table Based On Time Parameters

Hello Internet Friends,   I'm having trouble figuring out how to insert a column into a datatable that I'm querying in, to show what particular shift a Transaction Time fell within. I'll then be us...
Need Help
  • FreemanZ's avatar
    FreemanZ
    1 year ago

    hi mrolly ,

     

    try to write a calculated column like:

    Column = 

    VAR _time = [Transaction Time] -TRUNC([Transaction Time])

    RETURN

    SWITCH(

        TRUE(),

        _time >= 7/24&&_time<15.5/24,

        "Shift1",

        _time >=15.5/24&&_time<1/24,

        "Shift2"

    )

mrolly's avatar
mrolly
Regular Visitor
1 year ago

FreemanZ , I played around with it a little bit and figured it out! Just adding the solution that worked for me here for anybody in the future that is trying to do this so they have the working calc!