Need a Cascading filter on Dashboard Report for Category/Subcategory (sys_choice table)

[dgarod]

I need to create a report on a Dashboard that uses a filter similar to the Interactive Cascading filter, however the fields are not Reference fields, but Choice fields defined in sys_choice table like Category and Subcategory. I have not been able to find anything on this topic. 

Please help.

[Akshata jamdar]

Hi,

Below is the link of docs which help you to create interactive filter for choice field,

Please refer below link,

https://docs.servicenow.com/bundle/geneva-performance-analytics-and-reporting/page/administer/homepa...

Please mark the answer correct and helpful if it will help you in any manner.

Regards,

Akshata

[Adam Stout · Accepted solution]

Cascading filters only work on references.  So you have a few not ideal options:

1) Convert the choice lists to references

2) Use two choice list filters (which are limited to single tables)

3) Create a custom interactive filter

[dgarod]

OK, so this confirms my suspicion that this functionality does not exist out of the box. Hmm, would have thought this is easier than Ref fields.

Thank you Adam.