When filtering either a measure column with date values (click on the column header and select Filter rows) or Time dimension members on rows (click on Time dimension member row header and select Filter time) you can use either exact date name or relative date descriptions.
To filter Time dimension members on columns, you should use calculated members.
Table of Contents |
---|
Exact dates
When specifying date filter you can specify date in different formats, e.g. Dec 14 2012
or 2012-12-14
.
...
Those are the most commonly used expressions. For more examples of how to specify a dynamic date, please see Chronic library (which is used by eazyBIflex.bi) here: https://github.com/mojombo/chronic#examples.
...
30 days ago and today
1 week ago and 3 months from now
beginning of last month and one day before first day of current month
Example
Please find a short video on how to use a dynamic date filter when the "Time" dimension is used in rows of your report.
...