Add Variances

Contents

• Prerequisites
• Add Sales Revenue Variance
• Add Gross Margin Variance
• Summary

A variance on a chart shows the difference between versions of an account or to show the difference between time periods.

Review the Help Portal for more information on Variances in Charts.

In this lesson add variances to the Numeric Point Charts, to show the difference between 2023 and 2022 values as percentages.

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

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

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

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

   

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

   

Save a copy to your private folder.

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

   

Add Sales Revenue Variance

Add a variance to the Numeric Point Chart and compare Sales Revenue of 2023 with 2022.

Open your story in edit mode if not already.

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

   

5. Select Edit.

   

6. Open the Right Side Panel (Builder, Styling) from the View menu in the Top Toolbar, if not already open.

   

7. Select the Sales Revenue Numeric Point Chart.

   

8. In the Builder tab, expand Chart Add-Ons, and select Variance.

   

Edit COMPARE (A). Use the existing configuration of the Numeric Point Chart, Sales Revenue filtered by 2023 Order Date.

9. For COMPARE (A), keep the account as Dynamic, and click + Add Version/Time.

   

10. Select Order Date from the dropdown.

    

11. Keep the default Current Time Interval.

    

Edit TO (B). Compare to Sales Revenue of the previous year.

12. For TO (B), keep the Account as Dynamic, as Sales Revenue is the assigned account.

13. Keep the Time as Order Date, and Previous Time Interval.

    

Display the variance as a percentage instead of a dollar value.

14. Select Percentage, and keep the default 2 decimal places.

    

15. Click Done.

16. Quality Check: Does your Numeric Point Chart look like this?

    

Add Gross Margin Variance

Follow similar steps and add a variance to compare Gross Margin of 2023 with 2022.

17. Select the Gross Margin Numeric Point Chart.

    

18. In the Builder tab, expand Chart Add-Ons, and select Variance.

    

Edit COMPARE (A). Use the existing configuration of the Numeric Point Chart, Gross Margin filtered by 2023 Order Date.

19. For COMPARE (A), keep the account as Dynamic, and click + Add Version/Time.

    

20. Select Order Date from the dropdown.

    

21. Keep the default Current Time Interval.

    

Edit TO (B). Compare to Gross Margin of the previous year.

22. For TO (B), keep the Account as Dynamic, as Gross Margin is the assigned account.

23. Keep the Time as Order Date, and Previous Time Interval.

    

Display the variance as a percentage instead of a dollar value.

24. Select Percentage, and keep the default 2 decimal places.

    

25. Click Done.

26. Save your story.

    

27. Quality Check: Does your Numeric Point Chart look like this?

    

Summary

Well Done!! You have added variances to the Numeric Point Charts, comparing 2023 with previous year.