How to give Multi select in cascading filter , if this is not possible , how to achieve this using custom interactive filter?

[Pravallika1]

Hi Guys ,

I created a cascading filter on a database view and placed on a dashboard. The hierarchy is

1.User- To select any user from user table

2.Account - The Accounts are only in which the user is part of

But now the requirement is to select multiple users in the cascading filter. I was unable to find the option to give multiple select to a cascading filter. 

Please guide me how to give multiple select option to a cascading filter . If this is not possible , please suggest any ways to achieve this requirement.

If custom interactive filter is to be created , please help with the code as i am very new to this requirement.

[mcconnellsj]

To do it with a new Interactive Filter:

- Filter Based on "Reference"

- UI Control Type "Select Multiple Input"

- Reference Table - choose your table eg. account

- Add any conditions to filter the list

Click Save.

In the Interactive Filter references related list, create a New record for each table you dashboard is reporting on.  For example for case:

- Reference table "sn_customerservice_case"

- Reference field is the field that points to the table in your filter eg. account.

Add the interactive filter to your dashboard, make sure all reports have "follow filter".

If you have other reports on your dashboard that are referencing a different table, for example, contracts, you need to add it to the related list.

https://docs.servicenow.com/bundle/quebec-now-intelligence/page/use/dashboards/task/t_CreateAReferen...