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: 

For example:

Create an Estimated Close Monthly filter and use the bar chart widget data source dimension:

  1. To create a new opportunity filter.
    1. In Entity Manager select the Opportunity row.
      Note: Do not click the opportunity link.
    2. Click the Filters tab in the lower pane.
    3. Click the Add option. The Add Filter to Opportunity Entity dialog box is displayed.
    4. Select the In Dashboard? check box to expose the filter for widgets.
    5. Specify Estimated Close By Month in the Display field.
      Note: The Name field is automatically set to EstimatedCloseByMonth and cannot be modified.
    6. Click Type arrow and select Range from the list.
    7. Click Fields arrow and select EstimatedClose.
    8. Leave the Character field as 0. A value of 0 means that all characters must match.
    9. Click the Add option to add a range.
    10. Specify SlxMonthOfYear in the Range Name field.

      The range name must be named “SlxMonthOfYear”.

  2. Deploy the SlxClient portal. For more information see Deploying portals.
    Note: The filter is available only if the SlxClient portal is deployed.
  3. Create a column widget in the Dashboard or a Widget panel. See Working with a Column Chart widget and Widget Settings.
  4. To add the first data source:
    1. Click Add Data Source or Add Contextual Data Source in the Widget Settings window.
      Note: The Add Contextual Data Source option is available only for widgets on a detail view widget panel.
    2. Specify This Year in the Name box.
    3. Select a color to differentiate the data sources.
    4. Click the Entity drop-down arrow and select Opportunity.
    5. Click the Group drop-down arrow and select All Opportunities.
    6. Click the Dimension drop-down arrow and select Estimated Close By Month.
    7. Click the Metric drop-down arrow and select Average Sales Potential.
    8. Expand the Advanced section and select Query Builder.
    9. Click the +Rule button.
      1. Select Estimated Close in the first drop-down.
      2. Select is between as the operator in the second drop-down.
      3. Select This Year (Start) and This Year (End) in the last two drop-down menus.
    10. Click Save.
  5. To add the second data source:
    1. Click Add Data Source or Add Contextual Data Source in the Widget Settings window.
      Note: The Add Contextual Data Source option is available only for widgets on a detail view widget panel.
    2. In the Name box type Last Year.
    3. Select a color to differentiate the data sources.
    4. Click the Entity drop-down arrow and select Opportunity.
    5. Click the Group drop-down arrow and select All Opportunities.
    6. Click the Dimension drop-down arrow and select Estimated Close By Month.
    7. Click the Metric drop-down arrow and select Average Sales Potential.
    8. Expand the Advanced section and select Query Builder.
    9. Click the +Rule button.
      1. Select Estimated Close in the first drop-down.
      2. Select is between as the operator in the second drop-down.
      3. Select Last Year (Start) and Last Year (End) in the last two drop-down menus.