Cannot use data visualization as a filter

[SD2024]

I am trying to make a data visualization act as a filter: https://www.servicenow.com/docs/r/now-intelligence/make-dv-act-as-filter.html

I created these data visualizations on my dashboard:

dv1 - a pie dv with data source as the incident table grouped by Reported By and set the Allow Chart Interaction to Apply as filter.

dv2.- vertical bar dv with data source as incident table grouped by Reported by and select Follow Filter

If I click on a segment of the pie in dv1, it does not filter dv2. On dv2, if I click on the filter icon it shows: Filters not applied - Reported by.

 I do not have any filters on the dashboard.

What am I missing in the config to get this working? 

[GlideFather]

Hi @SD2024,

my quick idea was that there's not such a field in incident table... so I checked the available columns in the list view:

or you can check in the condition builder as well (it's checking the same)

What do you want to see in your data visualisation:

the impacted user >>> Caller (caller_id) or who submitted the incident >>> Opened by (opened_by)?

Use these fields in your DV to display the correct data, you can always check it in the table's list view to double check. Let me know your progress

[SD2024]

Hi @GlideFather 

Reported by is the caller_id field which I have renamed to Reported. Even if I group by another field like Active, the same thing happens - it shows Filters not applied - Active

[Tanushree Maiti]

Hi @SD2024 

Check this KB1648862 Platform Analytics: Unable to apply multiple filters on par data visualizations  , If it is  the same of your case.

Summary

In the platform analytics dashboard, some data visualizations function correctly with a single filter applied. However, when a second filter is added, it is ignored.

No issues are seen when each filter is applied individually, which indicates that the filters are set up correctly.

Steps to Reproduce

1. Create a sample platform analytics and add a Column data visualization on one of the out-of-the-box indicators, say, "Number of Open Incidents" --> Group by breakdown "State"
2.  Now add two filters based on indicator breakdown to the dashboard: Incident.Category and Incident.Priority
3.  Apply the filters individually, both of them apply successfully
4.  Now try to apply both the filters

Expected Behavior: Both filters apply

Cause

Working as expected!

Reason

As per the documentation: Create a Single/Multiple select or cascading filter, for a widget based on indicator data source type:

"Only two levels of breakdown can be applied to an indicator at the same time. On a dashboard, this could be two filters or one filter and a breakdown specified in the data visualization."

[GlideFather]

Hi @Tanushree Maiti,
Isn't it rather because they grouped data by a field that doesn't exist in that table? Most likely changed table after a filter was applied and somehow it stayed there..

Field Reported by in Incident table..