Dashboard Custom Interactive Filter for different fields on same table?

[Jay Gamblin1]

Is it possible to configure a dashboard custom interactive filter for different fields on same table?  For instance if you have two reports based on the incident table on a dashboard, but you need to filter one by sys_created_on and the other by opened_at?

I understand how to apply filters to more than one table at the same time as describe here. https://docs.servicenow.com/bundle/paris-now-intelligence/page/use/dashboards/reference/custom-interactive-filter-multiple-reports.html

But this only allows one field for each table.  In order to achieve this I would think one would have to specify the report in the filtering mechanism somehow otherwise how would it know to apply a filter to sys_created_on for one report that is based on incident and opened_at for another report also based on incident?

[bammar]

Hmm what is the actual difference between those values??..... if they are the same- adjust one of the reports so your using the same value. If you cant or dont want to.... the reports are actually the pool of records available to an interactive filter so if my gut is correct these are the same value- the interactive filter you set will still adjust both reports but may display the columns that are set to show on the reports.  You can surround the reports with many different interactive filters but each has to focus on one field- i wouldnt waste two on these.. If I am wrong will look with curiousity on other feedback you get.

[Adam Stout]

In your custom filter, you just have to build an OR into the encoded query.  Anything you can build into an encoded query can be used as a custom filter, you just need to be able to build the string in JavaScript.  I recommend starting with the Performance Analytics Academy on the topic.

https://community.servicenow.com/community?id=community_article&sys_id=f2db3382db8220d06621d9d968961...

[Hanleyp]

It appears the Academy topic on this is MIA. Would anyone have an example of such a script?

[Community Alums]

Hello! I have the same problem here, how did you solve it?