Editing Charts

Chart Goals

Show how close you are to your goal from your baseline by adding a goal visualizer to your Threshold or Bowling Charts.

Two Line OfieREQUIRED: The Chart Module is required to perform the functions on this support page. Reach out to your Customer Success Manager to enable Charts for your organization. 

Threshold and Bowling Charts both compare your actual data to a series of thresholds or targets, respectively. By adding a Goal (and its visualizer) to these Charts, you can make it easier to quickly check-in and, with a glance, see the progress being made.

The Goal is calculated with the equation (Data - Baseline) / (Target - Baseline), in which:

  • The Baseline is the first data point on the "Baseline Threshold" or "Baseline Target" series. If there is no such series, the first data point on the Data series associated with the Threshold or Bowling series will be used instead.
  • The Data is the last data point on the Data series associated with the Threshold or Bowling series.
  • The Target is the last data point on the "First Threshold" or "First Target" series.

As the equation suggests, the Goal can only be added and calculated once the following parameters have been met:

  1. A Threshold or Bowling series has been added to the Chart.
  2. A data series has been added to the Chart and has been associated with the Threshold or Bowling series.
  3. At least two rows of data have been added to the Chart.
  4. Values have been added for the "First Threshold" or "First Target" series.
Once the Goal has been added to a Chart and has been calculated, a Goal Visualizer will be added to the Chart's work panel. This Visualizer will include a percentage — the "score" indicating how close the data is to meeting the Goal — and a visual gauge, the color of which will match that of the last data point on the Data series.

A Chart work panel with the Goal Visualizer marked in red

Who can edit a Chart?

Only the following people can edit a Chart's Details or its data:

  • Anyone on the Chart's Team except for Followers or Participants.
  • Anyone with the “Edit” permission for Items in the Chart's Location(s).

Two Line OfieFor more information on Team Roles (like Authors, Facilitators, Participants, and more!) check out this article.

Add a Goal to a Chart

To add a Goal, open the Chart with which you want to work, then:

  • Click Actions in the top right corner of the page.

Bar-Line Chart work panel - Actions button

  • Click Edit Chart in the resulting drop-down menu and the Chart's Edit Data window will open.

Two Line OfieIf you need to build out your Chart in its entirety, check out the articles for your type of Chart: Threshold or Bowling. If your Chart is already built and you just need to add a Goal, proceed.

  • Click Options. The "Chart Options" window will open.
    • Goal Series — This option will only appear for Threshold and Bowling Charts which have had at least one data series associated with a Threshold or Bowling series.
      • Expand the drop-down to choose which data series should be used to calculate the goal percentage.
    • Click Save to save your changes and return to the Edit Data window.
  • Click Save on the Edit Data window to update the Chart. If all requirements have been met, the Goal will be calculated and the Visualizer will appear on the Chart's work panel.