Interactive filters with "Choice List" can't have multiple tables in a single interactive filter

[Nayana N]

We have a dashboard which contains reports from multiple table for example "Incident" and "Incident_SLA" and want interactive filters to act on the reports in dashboard, but found that Interactive filters with "Choice List" value can not have multiple tables in a single interactive filter . Kindly suggest for the same.

we need Choice List interactive filter to act on multiple reports with multiple tables.

[AndersBGS]

Hi @Nayana N ,

Which tables are you trying to filter with the interactive filter? For the mapping to the tables/columns, is it custom columns or OOTB columns? 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

[Nayana N]

My dashboard contains reports from 2 customised tables which are not related

[AndersBGS]

Hi @Nayana N ,

So the two customized tables, has they been created from scratch or extended from another table? Which field on both tables are you trying to filter on?

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

[Adrian Ubeda]

Hi Nayana, 
For achieving this you will need to create a custom filter widget, here's doc: https://docs.servicenow.com/bundle/utah-now-intelligence/page/use/dashboards/reference/r_CustomPubli...

Apart from this, you can create a database view and then apply filter over it as a single table, however this makes sense if both table are related, if not I will try a custom widget.