Add Threshold

Objective

After completing this lesson, you will be able to add a threshold to a table.

Contents

  • Prerequisites
  • Add Threshold Symbols
  • Change to Threshold Values
  • Summary

You can add thresholds to measures in tables, including calculated and restricted measures.

Review the Help Portal for more information on Using Thresholds in Tables.

In this lesson add thresholds to the table, to highlight the increase and decrease of the selected account.

After completing the lesson, your story (in edit mode) should look similar to:

Prerequisites

You have completed the following units and lessons:

  • Getting Started with SAP Analytics Cloud
  • Create your Story
  • Add Numeric Point Charts
  • Add Time Series Chart
  • Add Table
  • Add Geo Map
  • Explored Data with Just Ask
  • Linked Analysis and Input Controls
  • Add Variances

If you did not complete the prerequisite units, you can continue from a pre-created sample story.

Note

You already created a story, skip to

Please create a copy of MyStory - Select - Thresholds in your private My Files folder.

  1. From the Navigation Bar click Files, and search for MyStory - Select - Thresholds.

  1. Check the box, and click the Copy To icon from the Files Toolbar.

Save a copy to your private folder.

  1. Click on My Files and name your story with your username _MyStory, update Description, then click OK.

Add Threshold Symbols

Add a threshold number range to the finance table. Use the story-defined symbols and colors for the threshold ranges.

Open your story in edit mode if not already.

  1. Locate _MyStory from the navigation bar at Files > My Files, or Stories > Recent Files.

  2. Select Edit.

  1. Select the Table.

  2. Right click on the Delta cell, select Add Threshold, then + New Threshold.

The Thresholds panel opens on the right.

Within Thresholds, you can create a threshold based on a number range or against another measure. In our case, we are interested in a number range.

  1. Add 0 in the Min range input.

All values greater than 0 will be considered OK.

  1. Click + Add Range to add another range.

  1. From the label dropdown select Critical, and enter 0 as the Max range.

All values less than 0 will be considered Critical.

  1. Click Apply.

  1. Quality Check: Does your table look like this?

Change to Threshold Values

Change how the threshold is displayed, and use color values instead of symbols.

For the widget, you only see the styling options for the specific area that you have highlighted. For example the different areas are, Title cell, Header region, and Data cell. Selecting a different part of the widget changes the heading and the styling options.

  1. Open the Right Side Panel (Builder / Styling) from the View menu in the main toolbar, if not already open.

  1. Click on the Delta cell in the table, then click on the Styling tab for access to the Data Cell styling options.

  1. In the Styling tab, expand Threshold Style, and select Color Values.

  1. Click on Order Date to deselect the Delta cell.

  2. Save your story.

  1. Quality Check: Does your table look like this?

Summary

Well Done! You have added a threshold to a table and changed how the values are displayed.

Contents

  • Prerequisites
  • Add Threshold Symbols
  • Change to Threshold Values
  • Summary

You can add thresholds to measures in tables, including calculated and restricted measures.

Review the Help Portal for more information on Using Thresholds in Tables.

In this lesson add thresholds to the table, to highlight the increase and decrease of the selected account.

After completing the lesson, your story (in edit mode) should look similar to:

Prerequisites

You have completed the following units and lessons:

  • Getting Started with SAP Analytics Cloud
  • Create your Story
  • Add Numeric Point Charts
  • Add Time Series Chart
  • Add Table
  • Add Geo Map
  • Explored Data with Just Ask
  • Linked Analysis and Input Controls
  • Add Variances

If you did not complete the prerequisite units, you can continue from a pre-created sample story.

Note

You already created a story, skip to

Please create a copy of MyStory - Select - Thresholds in your private My Files folder.

  1. From the Navigation Bar click Files, and search for MyStory - Select - Thresholds.

  1. Check the box, and click the Copy To icon from the Files Toolbar.

Save a copy to your private folder.

  1. Click on My Files and name your story with your username _MyStory, update Description, then click OK.

Add Threshold Symbols

Add a threshold number range to the finance table. Use the story-defined symbols and colors for the threshold ranges.

Open your story in edit mode if not already.

  1. Locate _MyStory from the navigation bar at Files > My Files, or Stories > Recent Files.

  2. Select Edit.

  1. Select the Table.

  2. Right click on the Delta cell, select Add Threshold, then + New Threshold.

The Thresholds panel opens on the right.

Within Thresholds, you can create a threshold based on a number range or against another measure. In our case, we are interested in a number range.

  1. Add 0 in the Min range input.

All values greater than 0 will be considered OK.

  1. Click + Add Range to add another range.

  1. From the label dropdown select Critical, and enter 0 as the Max range.

All values less than 0 will be considered Critical.

  1. Click Apply.

  1. Quality Check: Does your table look like this?

Change to Threshold Values

Change how the threshold is displayed, and use color values instead of symbols.

For the widget, you only see the styling options for the specific area that you have highlighted. For example the different areas are, Title cell, Header region, and Data cell. Selecting a different part of the widget changes the heading and the styling options.

  1. Open the Right Side Panel (Builder / Styling) from the View menu in the main toolbar, if not already open.

  1. Click on the Delta cell in the table, then click on the Styling tab for access to the Data Cell styling options.

  1. In the Styling tab, expand Threshold Style, and select Color Values.

  1. Click on Order Date to deselect the Delta cell.

  2. Save your story.

  1. Quality Check: Does your table look like this?

Summary

Well Done! You have added a threshold to a table and changed how the values are displayed.

Learning
SAP FacebookSAP YoutubeSAP LinkedIn