Data visualization dynamic filter in ServiceNow

[J_47]

Hello All,

I am trying to create a dynamic filter on a Data visualization in UI builder. And I have done that however I am stuck with an issue.

Now lets assume i have created a report with data source as task sla

Now i want to create a report on filed XYZ which is available on  Incident and Request

The data filter source is defined as task sla->task->incident->XYZ / sla->task->Request->XYZ

Now when I apply the filter for field XYZ it just searched the first data filter and returns the value and does not go to the second data filter how to make sure that it searches both the data filter in UI builder.

Any help would be appreciated.

Thanks.

[Mark Manders]

You can't, if the value isn't the same. You aren't sharing what kind of field it is. If it's a reference field, it should work, but if it's a choice and the choices aren't shared (read: different values/sysids), it won't work. But that's just guessing, because we don't have that information.

[J_47]

Hello,

Yes the filter in reference. Let me give you an example of it.

Lets suppose the report is being created on task_sla table. 

Then i create a filter for assignment group. Assume the assignment group is a filed created on Incident/Change/Problem table.

Now so the data sources to filter that i need to apply would be  sla->task->incident->assignment_group / sla->task->Problem->assignment_group /  sla->task->change-> assignement group 

So i have applied three different data to filter sources. Now when we will apply the filter for asignemnt group it will onyl filter using the fist source in this case the Incident table and not go ahead and search for Problem and Change.

How to make it work so that it searches for all 3?