Add Time Series Chart

Objective

After completing this lesson, you will be able to add a Time Series chart to your story.

Contents

  • Prerequisites
  • Add Time Series Chart
  • Summary

Choose different chart types to display different aspects of your data.

Trend analysis is one of the best ways to analyze your data over a set time period. Time Series Chart is a type of trend chart that plots your data in a time frame line chart by default. Each point on the chart corresponds to a time and value.

Review the Help Portal for more information on Chart Types.

In this lesson, you add a Time Series Chart to your story.

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

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 - Time Series Chart in your private My Files folder.

  1. From the Navigation Bar click Files, and search for MyStory - Select - Time Series Chart.

  2. Select the checkbox, 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 Copy.

Add Time Series Chart

Open your story in edit mode if not already.

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

  1. Select Edit.

Add the Time Series Chart from the Left Side Panel.

  1. Open the Left Side Panel from the View menu in the Top Toolbar, if not already open.

  2. Click on the Main Lane to select area where to add the new widget.

  1. From the Left Side Panel under the Assets tab Drag & Drop the Chart widget onto the to Main Lane.

  2. Notice the Right Side Panel (Builder, Styling) automatically opens.

  3. In the Builder tab, expand the Currently Selected Chart dropdown, and select the Time Series chart.

  4. Click the Data icon in the Right Side Panel to get a list of all available objects in the data model, and drag Gross Margin to the Accounts location, and Order Date to the Time location.

  1. Close the Data panel.

[Alternative] Another option to add Gross Margin and Order Date.

  1. [Alternative] Under Accounts, click on + At least 1 Account required and select Gross Margin.

  1. [Alternative] Under Time, click on + At least 1 Dimension required and select Order Date.

Close the Right Side Panel.

  1. Deselect the Right Side Panel (Builder, Styling) from the View menu in the Top Toolbar, to close the panel.

  1. Resize the chart to make it more readable.

  2. You can now see Gross Margin by time in the Time Series Chart.

  1. Select a different time series (e.g. 3 months) and see the chart and slider gets updated.

  1. Save your story.

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

Note

After closing and opening your saved story, the Time Series Chart will default to display

Summary

Well Done! You have added a Time Series Chart.

Contents

  • Prerequisites
  • Add Time Series Chart
  • Summary

Choose different chart types to display different aspects of your data.

Trend analysis is one of the best ways to analyze your data over a set time period. Time Series Chart is a type of trend chart that plots your data in a time frame line chart by default. Each point on the chart corresponds to a time and value.

Review the Help Portal for more information on Chart Types.

In this lesson, you add a Time Series Chart to your story.

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

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 - Time Series Chart in your private My Files folder.

  1. From the Navigation Bar click Files, and search for MyStory - Select - Time Series Chart.

  2. Select the checkbox, 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 Copy.

Add Time Series Chart

Open your story in edit mode if not already.

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

  1. Select Edit.

Add the Time Series Chart from the Left Side Panel.

  1. Open the Left Side Panel from the View menu in the Top Toolbar, if not already open.

  2. Click on the Main Lane to select area where to add the new widget.

  1. From the Left Side Panel under the Assets tab Drag & Drop the Chart widget onto the to Main Lane.

  2. Notice the Right Side Panel (Builder, Styling) automatically opens.

  3. In the Builder tab, expand the Currently Selected Chart dropdown, and select the Time Series chart.

  4. Click the Data icon in the Right Side Panel to get a list of all available objects in the data model, and drag Gross Margin to the Accounts location, and Order Date to the Time location.

  1. Close the Data panel.

[Alternative] Another option to add Gross Margin and Order Date.

  1. [Alternative] Under Accounts, click on + At least 1 Account required and select Gross Margin.

  1. [Alternative] Under Time, click on + At least 1 Dimension required and select Order Date.

Close the Right Side Panel.

  1. Deselect the Right Side Panel (Builder, Styling) from the View menu in the Top Toolbar, to close the panel.

  1. Resize the chart to make it more readable.

  2. You can now see Gross Margin by time in the Time Series Chart.

  1. Select a different time series (e.g. 3 months) and see the chart and slider gets updated.

  1. Save your story.

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

Note

After closing and opening your saved story, the Time Series Chart will default to display

Summary

Well Done! You have added a Time Series Chart.

Learning
SAP FacebookSAP YoutubeSAP LinkedIn