SlxMonthly Date Range Filter
Use this date range of filter for comparisons of data grouped by month. You can specify the number of months before the current month as the lower value and months after the current month as the upper value. Any data before lower value can be grouped as Before <lower month> and any data after the upper value can be grouped as After <upper month>
To create a monthly range, specify SlxMonthly in the Range Name field.
In the Lower and Upper fields specify the number of months offset from the beginning of the current month.
For example:
- Create a monthly filter for the previous 6 months:
- Lower: Type -6
- Upper: Type 0
If the current month is October, then at run time the following range filter is created:
Month Label Lower Upper Before April Less than March 31 March 31 -6 April April 1 April 30 -5 May May 1 May 31 -4 June June 1 June 30 -3 July July 1 July 31 -2 August August 1 August 31 -1 September September 1 September 30 October and later October 1 Greater than October - Create a monthly filter for all 12 months. The value in the Lower and Upper fields must not be
specified.
If the current month is October, then at run time the following range filter is created:
Month Label Lower Upper Before April Less than March 31 March 31 -6 April April 1 April 30 -5 May May 1 May 31 -4 June June 1 June 30 -3 July July 1 July 31 -2 August August 1 August 31 -1 September September 1 September 30 1 October October 1 October 31 2 November November 1 November 30 3 December December 1 December 31 4 January January 1 January 31 5 February February 1 February 28 6 March March 1 March 31 April and later April 1 Greater than April