Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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.

...