Interactive Filter for External ID string field (Empty / Not Empty) on Dashboard

[ssaanvi]

Hi Everyone,

I have a requirement to add an Interactive Filter on a dashboard for the External ID field.

The requirement is to provide users with only two filter options:

• Empty – Displays only Incident records where External ID is empty.

• Not Empty – Displays only Incident records where External ID is not empty.

When a user selects one of these options, all reports on the dashboard should be filtered accordingly.

I tried implementing this using the standard Interactive Filter approach and followed the ServiceNow documentation, but I'm not getting the expected results. 

Has anyone implemented a similar requirement?

• Is this possible using an out-of-the-box Interactive Filter?

• If a custom solution is needed, could you please share an example or point me to the right approach?

Create a Core UI filter to tell if a field is populated • Australia Platform Analytics • Docs | Serv...

Any guidance or suggestions would be greatly appreciated.

Thank you!

[NagaChandaE]

Hi @ssaanvi ,

This is working for me. I created a boolean interactive filter in sys_ui_hp_publisher table on Incident Description Field. 

I have added this filter on a dashboard of a report shows count of incidents.
when i select yes it shows description field populated incidents
when i select no it show empty description incidents



Make Sure you checked the interactivity true

[ssaanvi]

Thank you for sharing this approach. I tried following the same process by creating an Interactive Filter record in the sys_ui_hp_publisher table and adding it to my Platform Analytics dashboard.

However, I’m facing an issue while configuring the filter:

• If I select True/False (Boolean) as the filter type, I’m unable to find or select the String field (such as External ID) from the filter source.
• If I select Single Select or Multi Select as the filter type, I can select the String field, but then the filter displays all the existing values from that field as options. I don’t get the True/False (Yes/No) options as shown in your example, and I also don’t have an option to select Empty/Not Empty.

My requirement is to have only two options in the filter:

• Empty – Show Incident records where External ID is empty/null.
• Not Empty – Show Incident records where External ID is populated.

Could you please let me know how you configured the filter so that a String field can be used with a Boolean/True-False filter? Is there any additional configuration required in the filter source or data source? Is it in platform analytics?

Any guidance on how to achieve this in Platform Analytics would be greatly appreciated. Thank you!

[ssaanvi]

Hi @NagaChandaE 

Could you please let me know if I am missing anything.

Thank you!

[NagaChandaE]

Hi @ssaanvi  ,

In Platform Analytics it is not supported. The Document also mentioned Core UI Filter which are traditional report filters.

Using platform analytics boolean filter your use case is not possible.
Traditional Report/Dashboards will support.