Case #3

Calculating and presenting year-on-year % change

Objectives

  • Apply a Rate of Change analysis
  • Display one series on an alternate axis
  • Combine line and area graphs in one chart
  • Synchronize the scale of the vertical axes

Solution

If you need more detailed help, have a look at the learning resources below, and download the Macrobond document for more details.

If you need more detailed help, have a look at the learning resources below.

Video (Note that since making this video we have further developed some elements in app and our structure of the data)

Worksheet

To the see exact construction of the document, you can download the file here.

Learning resources for this case

Different views – entry-points and how to work with them

Finding Data in Search

What is the analysis tree?

Working with the Analysis tree

Rate of Change analysis

Adding an alternate scale to charts

Graph layout