Filter Out when Criteria Met

[tf05]

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.

Name	Event Type	Status
18 ABC Street	1	A
18 ABC Street	2
18 ABC Street	2
18 ABC Street	2
18 ABC Street	3
18 ABC Street	4
18 ABC Street	5

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

Name	Event Type	Status
18 ABC Street	5

Thanks

[atcodedog05 · Accepted solution]

Hi @tf05 

Here is how you can do it.

Workflow:

Hope this helps : )

[RolandSchubert · Accepted solution]

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

[atcodedog05]

Happy to help : ) @tf05 

Cheers and have a nice day!