Using hierarchy in a runtime filter

Summary

Creating an if(expr & expr,1,0) filter using prod_hierarchy.id

Content

Hi all

Just wondering if anyone knows the answer to this one
I tried a few things but I'm unable to succeed.

If we take the following working example

if(incidents.c$incident_type.id = 151 & incidents.prod_id.id = 186, 1,0)

And if we want to have this in a filter as to exclude certain incidents where both the custom field and product id have a certain value we would have to use the hierarchy as prod_id is not available in filters.

So basically this (non working example)

if(incidents.c$incident_type.id = 151 & incidents.prod_hierarchy = 186, 1,0)