Using hierarchy in a runtime filter
SummaryCreating an if(expr & expr,1,0) filter using prod_hierarchy.id
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)