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
User | Count |
---|---|
36 | |
8 | |
3 | |
2 | |
2 |