Creating a Chart

Add a chart to your SAP Analytics Cloud story or to an analytic applications page, or apply other properties to a chart.

You can add many charts to your story or analytic applications page, and you can have more than one chart on a page. You can also run smart discoveries on your dataset to find unknown relationships in your data.

For information about all the parameters for the various chart types, see Choosing the Best Chart Type for the Data.

Creating Charts or Adding Special Features

In addition to adding charts to new and existing stories, you can set certain properties, apply smart grouping, and so on.

Add a Blank Chart to a New Story or Analytic Applications Page

  1. To add a chart to your story or analytic applications page, do the following:
    • Stories:
      1. From the (Main Menu), select Start of the navigation path(Stories) Next navigation step CanvasEnd of the navigation path.

      2. Select Chart.
    • Analytic applications:
      1. From the () Main Menu, select Start of the navigation path (Analytic Applications). Next navigation step  ApplicationEnd of the navigation path.

      2. Select Start of the navigation pathInsert Next navigation step ChartEnd of the navigation path
  2. In the Select Model dialog, select a folder and then select a data source:
    • Public: either search through the public folder for an existing model, spreadsheet, or other data source, or select the Models folder and then select a model.

    • Samples: select a model.

    If prompted, provide the proper login credentials for your data source connection.

The default chart type is a Bar/Column chart. You can change the chart type in the Chart Structure section of the Builder.

Add a Blank Chart to an Existing Story or Analytic Applications Page

To add a chart to an existing story or analytic applications page, do the following:
  1. From the (Main Menu), select Files.

  2. Select your story or analytic application.

  3. If you cannot edit the story or analytic application, select Edit.

  4. From the toolbar, under Insert, select (Chart).

    A bar chart is added to your page.

  5. If you already have a data source selected for another chart, that data source will automatically be selected for your new chart. To change it, in Start of the navigation pathBuilder Next navigation step Data SourceEnd of the navigation path, select (change primary model) and choose a new data source.

    If prompted, provide the proper login credentials for your data source connection.

You can select a chart type from the Chart Structure section of the Builder.

Properties

View Mode

Enable Explorer – select whether to enable the Explorer to be launched directly from the tile when in View mode.

Note

Explorer is not available when you use a data source that has multiple hierarchies in an account dimension.

If you want to restrict the number of measures and dimensions that are visible in the Explorer, select Configure Measures & Dimensions. Note that all measures and dimensions that are currently in the chart are automatically included and can’t be removed. Also, if you don’t specify any additional dimensions or measures, then only the ones used in the chart are available in the Explorer.

Boardroom

Select sorting options for when your story is used in the Digital Boardroom.

Applying Smart Grouping to Your Chart

Smart Grouping is available for both the Bubble and Scatterplot chart types when using a Correlation analysis.
Note
Before you can create a forecast on a time series chart, using a remote model from an SAP HANA, SAP BW, SAP Universe or SAP S/4HANA system, your administrator must configure the following option: Enable Time Series Forecast and Smart Grouping on Live Data Models. The data will be processed on SAP servers.
Use Smart Grouping to automatically analyze the data points in your chart and group them based on similar properties.
Note
By using Smart Grouping, any previously defined color settings for the chart will be overridden.
  1. Create either a Start of the navigation pathCorrelation Next navigation step BubbleEnd of the navigation path or a Start of the navigation pathCorrelation Next navigation step ScatterplotEnd of the navigation path chart.
  2. Select measures and dimensions for the chart.
    Note
    To successfully use a bubble chart, the resulting measure values cannot be negative.
  3. In Builder expand Smart Grouping and set it to On.

    A range slider for the number of groups is displayed.

  4. Specify the number of groups, the group name, and whether to include tooltip measures in the grouping.
    Note
    Use Start of the navigation path (More Actions) Next navigation step Add Tooltip Next navigation step MeasureEnd of the navigation path to add a tooltip measure to the chart.