SlxYearly Date Range Filter

Use this date range filter for comparisons of data across different years. You can specify the number of years before the current year as the lower value and years after the current year as the upper value. This filter is useful as a dimension for bar, column, and line chart widgets with multiple data sources.

To create a yearly range, specify SlxYearly in the Range Name field.

By default, the range is set to the current year with a Lower value of -3 and an Upper value of 3, resulting in 6 year ranges.

To change the number of years, in the Lower field specify a negative number to identify the number of years before the current year and in the Upper field specified a number to identify the number of years after the current year.

For example:

  • If the Lower and Upper fields are not specified:
    Year Label
    -3 2023
    -2 2024
    -1 2025
    1 (Current) 2026
    2 2027
    3 2028
  • If the Lower value is –2 and Upper value is 4:
    Year Label
    -2 2024
    -1 2025
    1 (Current) 2026
    2 2027
    3 2028
    4 2029

For example:

Create an Estimated Close By Year filter and use the 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 on 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 Year in the Display field.
      Note: The Name field is automatically set to EstimatedCloseByYear 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 SlxYearly in the Range Name field.

      The range name must be named SlxYearly.

  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. In the Name box type Potential.
    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 Year.
    7. Click the Metric drop-down arrow and select Average Sales Potential.
    8. Click Save.
  5. 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 Actual.
    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 Year.
    7. Click the Metric drop-down arrow and select Average Actual Amount.
    8. Click Save.
  6. Click Save.