Is it possible to get widget data based on another one in Dashboards?

[Shlesha1]

Is it possible to display widget data based on another widget 

e.g - 1st widget has table report. If user clicks on one of the count then other widget should display data replated to that in dashboard?

[SC15]

@Shlesha1-

Lets say you have a report [in widget #1] based on date [in widget #2].

Your widget #1 data can be based on widget #2 data.

How to configure your widget #1 to respond with any change you make in widget #2:

- click on gear icon of widget #1

- Check the box for "Follow interactive Filter" [ensure that you have setup widget #2 as "Act as interactive filter"]

Let me know if this assists you with your question. Please mark the solution helpful so others can benefit too. Thanks

[Shlesha1]

Hi @SC15 ,

Thank you for your response. Could you please advise how to set Widget 2 as Interactive filter.

[Shlesha1]

Also, my reports are like table chart and then list view. 

So consider I have above report added and then Incident list view below. So if user clicks on New - Critical count 2 then other list view should display only those 2 records.

I am aware this can be done in UI builder however I am trying to achieve this in Dashboards and native ServiceNow.

[SC15 · Accepted solution]

@Shlesha1 

The response stays the same for the process.

Have you tried these steps on your widget that shows the table chart? If you are not seeing the "act as interactive filter" under Edit widget that means you cannot use this style of report on the widget to have another widget mimic results for when you click on count = 2 [or any number]. In this case change the type to may be a pie/bar chart that is going to show you the count.

Once you have such a report in the widget, ensure that in your second widget you have "follow interactive filter" checked under widget settings. This will allow the report in this widget to display the records that you clicked on in your first widget.

Hope this helps in understanding that not all report types will allow you to do this when put in a widget on a dashboard.

Please feel free to reach back with your results or any questions. Good Luck!