Configuring Metric Timeframe Chart Sections

Overview

The Metric Timeframe Chart displays metric data over a period of time. The following chart types are available in the Metric Timeframe Chart:

  • Stacked Column & Line
  • Stacked Column
  • Column
  • Line
  • Column & Line

When reviewing charts, you can:

  • Filter content on the chart by clicking on the data series displayed in the chart legend. This will show or hide the data series in the chart.
  • Hover over any data series in the chart to view the values for that time period (especially helpful in stacked charts).
  • Export your chart as a PNG file by selecting the settings gear on the section and choosing the “Export” option.

Adding a Chart

  1. On a layout in Design mode, open the Add Section dialog.
  2. Select the Chart option from the left panel.
  3. Choose the Metric option under the Timeframe category, the Chart will be added to the layout.

Configuring Metric Chart Settings

After successfully creating a new Chart section, follow the steps below to fully configure your new Chart section. These configuration options can be edited on an existing Chart section via the Settings dialog while in Configure mode on a layout.

Data

  1. Click on the Settings icon (gear) at the top right of the Chart.
  2. Select Settings.
  3. Select the Frequency for the data to be displayed on the X-Axis (Daily, Weekly, Monthly, Quarterly, Yearly).
  4. Choose a date Format (ex. MM-YYYY or FY-YY). Daily frequencies will show the full date. Weekly frequencies will show the full start date of the week.
  5. In the Timeframe drop-down menu, choose a Custom date or a configured Date Range Page Filter.
    • If ‘Custom’ is chosen for the Timeframe, Start and End Date fields will be visible to enter expressions for the desired dates (ex. Program_Start__c to Program_End__c or “2025-01-01”, etc.).
  6. Define the Datasource: the template where the metrics are defined. In the Type field, open the drop-down menu to see all available templates.
  7. Optionally, locked Filters can be set when configuring a Chart section. These filters will apply to all content in the Chart and cannot be seen or edited by end users viewing the Chart. Page Filters can be referenced using the injected expression syntax: {!toFilter(API_Name__f)}. Refer to the Page Filtering article for more details on configuration.
    1. The Attribute drop down menu will show attributes from the template type selected. Select an Attribute.
    2. If the Attribute has Data Sets enabled, define the Data Set. Otherwise it will default to ‘Actual’.
    3. Enter a value into the Value field. Filtering syntax can be found here.
    4. Add another filter by clicking Add Filter.
    5. Remove a filter by clicking the trash icon next to the filter.

Display

On the Display tab, you’ll select the type of Chart to display, the metric values to display and their data set(s), format the values, and configure additional chart display options.

When you select a Chart type, the Value options will change depending on the Chart Type selected. For the Stacked Chart types, you must select the grouping method (Metric Name, Item Name, Associations or Pick Lists).

Follow the steps below to configure the Chart Display:

  1. Select a Chart Type.
  2. Add one or more values to display in the Chart. Start by selecting a Metric from the Value 1 drop-down menu, then define which Data Set will be displayed for the Metric. Finally, choose from one of the available value aggregation options (Sum, Average, Min, Max). Notes:
    • You can select an existing Data Set Page Filter within the Data Set dropdown.
    • Stacked Column Chart Types do not support value aggregation.
  3. Add additional Values by selecting the Add Value button, you can also remove values by clicking on the trash can icon next to a value.
  4. (If Chart Type is Stacked Column or Stacked Column and Line) Define the Slice By (Group By) from the drop-down menu. This setting determines the stacks of the column. It is locked to Metric Name if more than 1 value is selected. For a single metric, you can slice by Association, Item Name or Pick List. Note: When slicing by an Item Name or Association, the Out-of-the-box Color attribute will be used for the respective work item’s value in the chart.
  5. Enable the Format Values setting to customize the display Label and the Color for each individual Value on the Chart. Note: You cannot format the label or color of Stacked Columns sliced by Associations or Item Name.
  6. Under the Options accordion, you can define whether the Chart will have a legend, and if the chart values are displayed at all times.
  7. Save and Publish your changes.
Updated on May 29, 2024