Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.

Show data in VIEW by selecting two dates from other table

Hello everyone. 

I am trying to show data selected by view between two dates. 

I have a table "sheet1" and make a slice "iDetail" using this expression:

AND([Time] > DATE("10/04/2023"), [Time] < DATE("10/08/2023")) - where Time is a data variable in the table. 

THen I created a view "filter" and use two column "startdate " and "enddate" in an additional table "ReportIDetail". 

Then I created a view" iDetail" and used these two columns from the table "iReport".

Idea is that user should select data in VIEW "iRepor" and then the slice "iDetail" should filter data using start and end data. 

I tried this expression:

AND([Time] > date(ReportIdetails[Startdate]), [Time] < date(ReportIdetails[End date]))

I am getting data from the Slice but it is not filtered. 

Would be great if you can please tell me how to manage this? 

 

Thanks and best regards

 

0 6 378
6 REPLIES 6
Top Labels in this Space