Document toolboxDocument toolbox

Date filters

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.

Exact dates

When specifying date filter you can specify date in different formats, e.g. Dec 14 2012 or 2012-12-14.

If you specify just month (Dec 2012) then it will be the same as the first date of the month (Dec 01 2012).

If you specify just year (2012) then it will be the same as the first date of the year (Jan 01 2012).

Relative dates

If you want to specify a dynamic date range then you can use the following relative date names which will be calculated as an offset from the current date during the report data query. Here are examples of relative dates:

  • todaytomorrowyesterday
  • 1 day ago30 days ago (past dates)
  • 1 day from now30 days from now (future dates)
  • 1 week ago4 weeks ago1 week from now4 weeks from now
  • 1 month ago3 months ago1 month from now3 months from now
  • 1 year ago2 years ago1 year from now2 years from now

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 flex.bi) here: https://github.com/mojombo/chronic#examples.

Relative date ranges

If you click on date columns and select Filter rows / between or if you put Time dimension on rows and click on the year, quarter, month, week or day row header and select Filter by name / between then you can enter a dynamic date range that will be calculated from the current date. For example:

Time between

  • 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