How to set different Interactive Filter for 2 Report with same table in Dashboard

[Dinh Nguyen]

Hello everyone, 

 I had difficulty trying to get two reports with the same table to receive filters based on two different fields. It always returns the same data as below:

Please someone help me. Thank you so much

[James Chun]

Hi @Dinh Nguyen,

Since your filter is fetching all the records (it's fetching all the records created/updated today or before), you are seeing the same result in both results.

What is your requirement?

Cheers

[Dinh Nguyen]

Hi @James Chun ,

My requirement is :

 + Report "Incident By Created By" is base on field Created : (2024-04-01 <= Created < 2025-04-01)

 + Report "Incident By Updated By" is base on field Updated : (2024-04-01 <= Updated < 2025-04-01)

I used the Content Block to create a filter as shown above, you can see the result in Widget Debug. But can't make it run as expected.

Is there a way for 2 reports on the same table to receive 2 different interactive filters?

[James Chun]

Hi @Dinh Nguyen,

Are you saying that the interactive filter needs to be applied to two different reports but to different fields?

In this example, the date filter needs to be applied to the Updated field on one of the reports and the Created field on the other report.

[Dinh Nguyen]

Hi @James Chun ,

 Yes. And two different reports using table that's Incident.