After stumbling into this post, I decide to try integrating it to my app so user can filter data based on criteria they specified. I want the user to specify a start date, end date and the system has there user email. With this criteria filter the table "Expenses" to see which points fit that criteria. But I cant seem to make the formula work. This is what I have so far:
FILTER("Expenses",
AND(
OR( ISBLANK([_THISROW].[Employee ID Input]) , CONTAINS (Expenses[Employee ID],[_THISROW].[Employee ID Input])),
OR( ISBLANK([_THISROW].[Start Date]) , [Date] >= [_THISROW].[Start Date] ),
OR( ISBLANK([_THISROW].[End Date]) , [Date] <= [_THISROW].[End Date] )
)
)
While it does filter correctly for start and end date, it doesn't filter for Email.
As you can see the email says Amanda but I'm Gabriel. Any help to make this work by filtering the email correctly will be appreciated.
Solved! Go to Solution.
If you want to filter with the app user, would that part be then just as simple as..
[Employee ID]=USEREMAIL()?
User | Count |
---|---|
16 | |
11 | |
7 | |
2 | |
2 |