Filter Out when Criteria Met

Question

I have the same property with different events / statues attached to them. When a certain status is met, I want to filter out all but one event type.

NameEvent TypeStatus18 ABC Street1A18 ABC Street2 18 ABC Street2 18 ABC Street2 18 ABC Street3 18 ABC Street4 18 ABC Street5

When Status A is recorded, I want to filter out all Event Types except type 5. This would give me the output:

NameEvent TypeStatus18 ABC Street5

Thanks

atcodedog05 · Accepted Answer

Hi @tf05

Here is how you can do it.

Workflow:

Hope this helps : )

RolandSchubert · Accepted Answer

Hi @tf05 ,

I think it's a two-step-process - first identify names with status "A", then select records with event type 5 or not 5 for these names

Let me know if it works for you.

Best,

Roland