Ifelse calculated field, null data not excluded

[matanne]

Hi all,

I have inherited a dashboard and am trying to create a calculated field to only look at high severity events that are Tier 1 and Tier 2 but exclude the other tier levels for tracking a specific metric.

The calculated field is:
ifelse({severity_tier} = ‘Tier 1 - High Severity’ OR {severity_tier} = ‘Tier 2 - Moderate Severity’, {severity_tier}, NULL)

When using this field the null data still shows within the visuals but I want it to not show at all. Any pointers for how to exclude the extraneous data?

[David_Wong]

Hi @matanne,

You can add a filter to exclude null like this:

[matanne]

This was helpful and solved my problem! Thank you David!