How do i compare


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

  • You can create a beast mode that looks like this:

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

    ELSE 'Different'

    END

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • That is perfect Thank you worked beautifully

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

    **Check out my Domo Tips & Tricks Videos

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