Introducing SAP Analytics Cloud

Configuring Charts and Tables

Objectives
After completing this lesson, you will be able to:

After completing this lesson, you will be able to:

  • Configure charts and tables

Tables

Tables can be used to view and analyze data. Tables are added to either responsive, canvas, or grid pages in stories.

For tables that are based on models, the set of features and options available depends on the model type (planning, analytics, or a model based on a remote SAP HANA system). Only the features and options that are supported by the model type are visible. For example, tables based on planning models allow users to make changes to the model data using version management, data entry, and allocations.

When you add a table to a story, a data grid is created with the basic dimensions and categories of the model aligned along the axes of the grid. You can change this basic layout using the following designer tools:

  • Use the Builder Expert to select the measures and dimensions to include in the rows and columns of your table.

  • Use the Styling tools to format the presentation.

Table Configuration

Watch this video to learn about some of the table configuration options.

Note
  • If you select a table and choose "Examine", the system will display a chart below the table and vice versa.
  • If you select Model Members under the Account dimension, you can change the account description in the story.

Charts

Create charts in a story to display your data graphically. The data in your chart is based on the model you selected when creating the chart.

As shown in the figure below, you can select a chart type from the builder and then pick the measures and dimensions to show in your chart. Once you have defined the structure of your chart, you can add reference lines or filters to it. You can also customize color palettes.

You can choose from different categories of charts, such as, comparison, trend, correlation, distribution, indicators, and others (donut, pie, marimekkto).

Chart Scaling

Chart scaling ensures that you have a consistent display of values across multiple charts. Watch this video to learn how you can scale charts.

Note
  • Chart scaling is applied to all of the pages in a story, but the scaling may be different for the same measure on different pages, because the scaling factor is calculated separately for each page.

  • You can exclude charts from the scaling. For example, if a chart contains data that is much larger than the data in other charts, the other charts look smaller than they should and could be misleading to the viewer.

Variances in Charts

Variances in your charts let you show the difference between versions of a measure or the difference between time periods.

As illustrated in the figure Example of a Variance Chart, you can use the variance chart component for any two measures, even if the measures do not appear in your base chart. You can create variances that do not include the versions for the measures, as well as variances that do include time periods.

You can also create a dynamic variance, a variance that is based on the measures in the chart context. If you change the measures in the chart, the variance automatically updates.

Note

To include time in your variance, you must have the Date dimension in your chart or in an input control.

For some chart types (numeric point, for example), when the variance uses a Time Range filter, the range must be set to only one interval (year, quarter, or period).

When using models from live data connections, you must include version information with your measures, and your measures must be in your base chart. Using measures without versions applies to local models only.

Charts Trellis

A trellis will reserve the first dimension to create a chart with the remaining dimensions and expressions for every value of the first dimension that is selected.

R Visualization

R is a programming language used by data scientists. We can easily integrate R into SAP Analytics Cloud. The figure below illustrates how native R visualization support enables you to visualize and analyze data without limits.

The R server runtime environment provided by SAP allows you to access interactive R visualizations with an automatically configured R server.

R Visualization Widget

You use the R visualization widget to create and edit visualizations based on R scripts. By setting the relevant properties, you can change the size and style of the widget.

The R visualization widget is used in both stories and analytic applications.

Configure Charts and Text Widgets

Task Flow

In this exercise, you will perform the following tasks:

  • Add a reference line
  • Add a variance
  • Add a trellis
  • Add a tool tip
  • Use chart scaling
  • Format pages
  • Format charts and data labels
  • Add dynamic text

Save progress to your learning plan by logging in or creating an account