Use of Dashboard Interactive filter on two different table

[Nadir Abbas]

I am facing problem which is that i have an event interactive filter to populate data of two reports based on two different table. The main issue is, there is no common filed in both table. How can i do that?
Can anyone help me?

[AndersBGS]

Hi @Nadir Abbas ,

Please explain your issue/requirement in further in details. I do not understand from the information that you have provided. 

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

best regards

Anders

[Nadir Abbas]

In my understanding, interactive filter is work on all reports which have same tables. so i were little confused about different tables because in my case, two report have different tables not populating data according to filter search.

Another thing which i discovered was that there were not common filed in both reports which linked to filter.
so my question was to make sure, is it possible to populate data in two reports which have different tables? if yes then, is it necessary to have common field in both reports?

[AndersBGS · Accepted solution]

Hi @Nadir Abbas ,

An interactive filter can filter multiple tables if the association is the same. e.g. 

Incident table --> Caller field

Requested item --> open for field

An interactive reference filter for sys_user will filter both reports / tables. 

Look at the "interactive filter references" as below, then you should see which tables the interactive filter is filtering on.

Which tables are the two reports created on and what field is utilized in the interactive filter.

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

best regards

Anders