Support center for flex.bi version 4.0
How to filter Time dimension members - last 3years, time until today?
When creating filters on Time dimension members on rows (clicking on Time dimension member row header and selecting Filter time) you can use either exact date name or relative date descriptions.
See Sample Report from Templates
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 dynamic date range then you can use the following relative date names which will be calculated as offset from current date during report data query. Here are examples of relative dates:
today,tomorrow,yesterday1 day ago,30 days ago(past dates)1 day from now,30 days from now(future dates)1 week ago,4 weeks ago,1 week from now,4 weeks from now1 month ago,3 months ago,1 month from now,3 months from now1 year ago,2 years ago,1 year from now,2 years from now
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 year, quarter, month, week or day row header and select Filter by name / between then you can enter dynamic date ranges that will be calculated from current date. For example:
Time between
30 days ago and today1 week ago and 3 months from nowbeginning of last month and first day of current month
More examples
Please see more examples of how to specify dynamic date in Chronic library (which is used by flex.bi) description.