•Criteria – Enable Users to Specify Event Start Date Range
•Criteria – Enable Users to Specify Event End Date Range
In this example, we will create an event BI query to filter events by the Liberty venue and enable users to run the query by date range.
Filter for Liberty Venue
Field |
Value |
Category/Criteria |
Venue/Venue |
Type |
Match Condition |
Operator Type |
And |
Function |
Blank |
Condition |
Equals |
Values |
Liberty |
Criteria – Enable Users to Specify Event Start Date Range
Field |
Value |
Criteria |
Event/Start Date |
Type |
Match Condition |
Function |
Blank |
Condition |
Between (including both values) |
Values |
Blank |
Criteria – Enable Users to Specify Event End Date Range
Field |
Value |
Criteria |
Event/End Date |
Type |
Match Condition |
Function |
Blank |
Condition |
Between (including both values) |
Values |
Blank |
