Bowling Charts

Monitor Key Performance Indicators (KPIs) or policy deployment objectives with Bowling Charts.

Bowling Charts are an easy way of checking in on how often your goals were met or missed. If you’re looking for that basic information, this may be the perfect tool for you.

Example of a Bowling Chart. You can easily see when targets were achieved or missed based on the red and green highlight colors. 

Who can edit a Bowling 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).

Edit a Bowling Chart's Details

A Chart's Details consist of its non-data elements including:

• Fields and Attributes
• Its parent — the Item under which the Chart is nested
• Other settings such as whether or not the Chart should be private or be granted Honor Roll may be available depending on how your organization has configured its Charts and your own permissions within the system.

To edit a Chart's Details, open the Chart with which you want to work, then:

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

• Click Edit Details in the resulting drop-down menu.
• Update any of the aforementioned elements.
• Click Save.

Enter data for a Bowling Chart

You will use the data entry window to enter data for your Chart. A Chart's data includes not only the individual data points but also how those data points are displayed.

To start entering data, open the Chart with which you want to work, then:

• Either click Actions in the top right corner of the page or click the ellipsis in the top right corner of the panel containing the Chart.

• Click Edit Chart in the resulting drop-down menu.
• The Chart's data entry window will open. By default, Charts are Bar/Line Charts. After at least one Bowling Series is added, it becomes a Bowling Chart. 
  

In the data entry window, you can: 

• Decide whether the Chart will use dates or categories
• Add a Bowling series
• Add a data series
• Edit an existing data series
• Delete an existing data series
• Add data rows
• Delete data rows
• Add and update data points
• Export data
• Import data

Switch between Date or Category

A Bowling Chart's data can be either date-based or category-based. By default, a new Bowling Chart will use dates.

To change which is used, open the Chart's Edit Data window as described above, then:

• Click the pencil icon next to "Date" or "Category."

• In the resulting window, click either the Date or Category radio button to make your selection.
• If you select "Category," click Save.
  
  If you select "Date," additional configuration options will appear.
  • The Use exact dates entered checkbox: When this box is checked, the Chart will display the exact dates entered. When this box is unchecked, the Chart will automatically calculate the best dates to display to create an even interval between the dates entered.
  •  The Show time on Chart checkbox: When this box is checked, the date and time for each data point will be displayed on the Chart. When this box is unchecked, only the date will be shown for each data point.
  • Click Save.

Add a New Bowling Series

A Bowling series consists of one to four targets — meaningful goals to which data is compared.

To create a new Bowling series, open the Chart's Edit Data window as described above, then click Add Bowling Series. The "Add Bowling" window will open:

• Name (required): The name will be used to identify this series.
• Description: Enter an optional description in this field. The description will appear when hovering over the name of the series on both the Edit Data window and on the Chart's legend.
• Format (required): Expand the drop-down to choose in which format you want data in this to be displayed. Once you've made a choice, the predefined format will appear in the field. Edit that predefined format to configure the appearance of this series's data further.
• Do you want your data to be above or below the Targets (required): Expand the drop-down to choose whether a Target should be considered "met" if data points lie below it or above it.
• Color of data points when no Target is met: Click inside the color code field to open the color picker, choose in which color a data point that meets no Target will be displayed, then click Save on the color picker.
• Under the "First Target" header:
  
  • Title: The title will be used to identify this Target.
  • Color of data points when this Target is met: Click inside the color code field to open the color picker, choose in which color a data point that meets the First Target will be displayed, then click Save on the color picker.
  • The Flag if Target is not met checkbox: When this box is checked, a notification will be added to this Chart whenever the most recent data point does not meet this Target.
  • Click the Appearance subheader to open that section:
    
    • Line Color: Click inside the color code field to open the color picker, choose in which color this Target will be displayed when the Chart is in Chart View, then click Save on the color picker.
    • The Show Markers checkbox: When this box is checked, a round marker will appear at each data point on the Target's line when the Chart is in Chart View.
    • The Show Values checkbox: When this box is checked, the value of each data point on this Target will appear by its line when the Chart is in Chart View.

• • • The Send to Back checkbox: When this box is checked, this series's line will be arranged behind any other series when the Chart is in Chart View.
    • The Dashed Line checkbox: When this box is checked, this series will be displayed as a dashed line rather than a solid line when the Chart is in Chart View.
  • The Second Target checkbox: Select this box to add a Second Target to your Bowling Chart. The Second Target should be between the current state and the First Target. Repeat the process above to set its appearance details. 
  • The Third Target checkboxes:  Select this box to add a Third Target to your Bowling Chart. The Third Target should be between the current state and the Second Target. Repeat the process above to set its appearance details. 

• • The Baseline Target checkbox: Select this box to add a Baseline Target to your Bowling Chart. The Baseline Target represents the minimum acceptable threshold for your metric. Repeat the process above to set its appearance details. 

• • Click the Annotation Appearance header to open that section.
    
    • Click inside the color code field to open the color picker, choose in which color Annotations on this series will be displayed, then click Save on the color picker.
  • Click Save to create the Bowling series and return to the Edit Data window or click Save & Add Data Series to create the Bowling series and immediately open the "Add Data Series" window.

Add a Data Series

A data series consists of the data which will be compared to the Targets.

When you add data to a Chart for the first time, there will be a blank data series column you can use to enter data immediately. 

• Click into each cell and enter a value. 
• Select the pencil icon to edit the data series. You can make changes such as updating the data series' color and whether it appears as a bar or a line. 

There are two ways to add a new data series to your Chart. 

• You can select the + button to the right of your existing data series. A new column will appear, and you can start entering data immediately.
• Or, you can select Add Data Series. The “Add Data Series” window will open, and you can enter the new data series settings before entering the data itself.

In the Add Data Series window or Edit Data Series window (if you are updating an existing Data Series), you can update the following settings:

• Name (required): The name will be used to identify this series.
• Description: Enter an optional description in this field. The description will appear when hovering over the name of the series on both the Edit Data window and on the Chart's legend.
• Format (required): Expand the drop-down to choose in which format you want data in this to be displayed. Once you've made a choice, the predefined format will appear in the field. Edit that predefined format to configure the appearance of this series's data further.
• Associate this data series to the following threshold, control limit, or bowling series: Expand the drop-down to choose with which of the Chart's Bowling series this data series will be associated.

• Under the Type header:
  
  • Click either the Line or Bar radio button to decide whether this series should be displayed as a line or as a bar when the Chart is in Chart View.
• Click the Appearance header to open that section. The options shown here will be largely determined by your choice of line or bar above.
  
  • If this is a line data series:
    
    • Bar/Line Color: Click inside the color code field to open the color picker, choose in which color this series will be displayed when the Chart is in Chart View., then click Save on the color picker.
    • Line Width: The value (1–10) entered here will determine the width of this series's line when the Chart is in Chart View.
    • The Show Markers checkbox: When this box is checked, a round marker will appear at each data point on the series's line when the Chart is in Chart View.
    • The Show Values checkbox: When this box is checked, the value of each data point on this series will appear by its line when the Chart is in Chart View.

• • • The Send to Back checkbox: When this box is checked, this series's line will be arranged behind any other series when the Chart is in Chart View.
    • The Dashed Line checkbox: When this box is checked, this series will be displayed as a dashed line rather than a solid line when the Chart is in Chart View.
    • The Fill checkbox: When this box is checked, the space beneath the series's line will be filled in when the Chart is in Chart View. If enabled, the following options will appear beneath the checkbox:
      • Fill Color: Click inside the color code field to open the color picker, choose in which the fill for this series will be displayed, then click Save on the color picker.
      • Fill Opacity:  Expand the drop-down to choose with what opacity you want the fill to be displayed.
  • If this is a bar series:

• • • Bar/Line Color: Click inside the color code field to open the color picker, choose in which color this series will be displayed when the Chart is in Chart View., then click Save on the color picker.
    • The Show Values checkbox: When this box is checked, the value of each data point on this series will appear by its bar when the Chart is in Chart View.
• Click the Y-Axis header to open that section.
  • Click either the Left or Right radio button to decide whether Y-axis for this series should be displayed on the left or right side of the Chart when in Chart View.
• The Calculated Series checkbox: Check this box to turn this series into a Calculated series. Such a series will calculate the sum, difference, average, percent, percent change, product, or quotient of other data series currently on this Chart. If checked, the "Shared Series" header will disappear and a new field will appear:
  
  • Operator: Expand the drop-down to choose which operator the Calculated series will use. Depending on the operator chosen, additional required fields will appear.
    
    • If Sum, Average, or Multiply are selected:
      
      • Series: Expand the drop-down to select every data series that should be used in this calculation.
    • If Difference is selected:
      
      • Series to subtract from: Expand the drop-down to select the data series from which the other data should be subtracted.
      • Series to subtract: Expand the drop-down to select every data series that should be subtracted.
    • If Percent or Divide are selected:
      
      • Numerator Series: Expand the drop-down to select the data series that should act as the numerator.
      • Denominator Series: Expand the drop-down to select the data series that should act as the denominator.
    • If Percent Change is selected:
      
      • Baseline or Original (% change from): Expand the drop-down to select the data series that should act as the baseline value.
      • Actual or Current: Expand the drop-down to select the data series that should act as the current value.
• The Shared Series checkbox: Check this box to turn this series into a Shared series — a series that is mirrored from another Chart. The data on such a series will not be editable on this Chart but will reflect updates made to the data series on the original Chart. If checked, the additional fields will appear:
  
  • Chart: Use this field to search for the Chart which contains the series you want to have shared. Once you've selected a Chart, the next field will be enabled.
  • Series: Expand the drop-down to select which data series from the specified Chart you would like to add.

• Click the Annotation Appearance header to open that section.
  
  • Click inside the color code field to open the color picker, choose in which color Annotations on this series will be displayed, then click Save on the color picker.
• Click Save to create the data series and return to the Edit Data window.
• Repeat this process for any additional data series you need to add.

Edit an existing series

To edit an existing series, open the Chart's Edit Data window as described above, then:

• Click the pencil icon next to the series's name.  The "Edit Series" window will open.

• Make any changes necessary as previously described.
• Click Save to update the data series and return to the Edit Data window.
• Click Save to update the Chart.

Delete an existing series

To delete an existing series, open the Chart's Edit Data window as described above, then:

• Click the pencil icon next to the series's name.  The "Edit Series" window will open.
• Click Delete. The "Edit Series" window will close and the series will no longer appear on the Edit Data window.
• Click Save to update the Chart.

Add rows

Once at least one series has been added to the Chart, you will be able to add rows. To do so, open the Chart's Edit Data window as described above, then:

• To add a single row, click Add Row.
• To add multiple rows at once, click Build Multi Rows. A new window will open so that you can specify how many rows will be added. The options on this window will differ based on whether the Chart is using dates or categories.
  • If using dates:
    
    • Start Date: Enter the date of the first row to be added.
    • End Date: Enter the date of the last row to be added.
    • Step Unit: Expand the drop-down to choose whether a row should be added for each day, each week, or each month between those two dates.
    • Click Save.
  • If using categories:
    
    • Row Count: Enter the number of rows that should be added.
    • Click Save.

• Once rows have been added, click the date or category field for each one to change its date or name.
• Click Save to update the Chart.

Delete Rows

To delete an existing row, open the Chart's Edit Data window as described above, then:

• Hover over the row you want to delete so that it's highlighted blue.
• Click the x button that appears to its right. The row will disappear from the Edit Data window.
• Click Save to update the Chart.

Add and edit data

Once rows have been added, individual data points can be entered. To do so, open the Chart's Edit Data window as described above, then:

• Click inside the appropriate column and row intersection. The selected cell will have a blue outline.
  
  
  • Enter the desired value. 
• Repeat this step for every data point that must be added.
  • Select "enter" on your keyboard to continue entering data in the same column. 
  • You can navigate between cells using the arrow keys or "tab" key on your keyboard. 

• Click Save to update the Chart.

Export the Chart's data

To export a Chart's data, open the Chart's Edit Data window as described above, then:

• Click the Excel File icon.

• Click Download in the resulting drop-down.

• If your Chart is using dates, you will need to select a Time Zone and then click Download in the resulting window.

Import data into a Chart

To import data into a Chart, open the Chart's Edit Data window as described above, then:

• Click the Excel File icon.
• Click Upload in the resulting drop-down.
• The "Chart Data Import" window will open:
  • If your Chart is using dates, you will need to select a Time Zone.
  • Either drag the file you want to import onto the resulting window or click the window and choose the correct file from your computer.
  • A confirmation screen will appear with details about your import. Click Ok, got it.

Everything else!