How do i compare

user091100 · 2021-06-22T14:24:13+00:00

There was an error rendering this rich post.

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

Find more posts tagged with

Comments

MarkSnodgrass

You can create a beast mode that looks like this:

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

ELSE 'Different'

END

user091100

That is perfect Thank you worked beautifully

MarkSnodgrass

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

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Best Of