How do i compare

user091100
user091100 ⚪️
in Card Building
image.png


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

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • 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.

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Categories