SlxMonthOfYear Date Range Filter
Use this date range filter for comparisons of data grouped by each month, but across last, this, and next years as defined as a dimension in a widget data source. This filter is useful as a dimension for bar, column, and line chart widgets with multiple data sources.
To create a month of year range for a widget data source dimension, specify SlxMonthOfYear in the Range Name field.
The value in the Lower and Upper fields must not be specified, as the values are automatically set for the 12 months of the year.
Note:
- The filter is available only if the SlxClient portal is deployed.
- When using a Month of Year date range filter as a widget data source dimension you must use the data source Advanced section to define the time frame. See the example in Using the Data Source SData entity where clause Query Builder.
For example:
Create an Estimated Close Monthly filter and use the bar chart widget data source dimension: