How do i compare

user091100
user091100 βšͺ️


I have a data set that is for fire drills we have a set scheduled shift i want to see when it is ran on a different shift so above the scheduled shift is the set shift the "Shift" is the one it was actually ran on.

I am guessing it will be an IF and then else statement but not sure exactly how

Comments

  • MarkSnodgrass
    MarkSnodgrass Portland, Oregon 🟀

    You can create a beast mode that looks like this:

    CASE WHEN 'Scheduled Shift' = 'Shift' THEN 'Same'

    ELSE 'Different'

    END

  • user091100
    user091100 βšͺ️

    That is perfect Thank you worked beautifully

  • MarkSnodgrass
    MarkSnodgrass Portland, Oregon 🟀

    @user091100 glad it worked for you. If you can mark the answer as accepted, that will help other people in the community.