Settings for Displaying of Measures

Let us look at how several measures are displayed on a chart on the following example of a report:

On the rows we have all months of the years 2016 and 2017 selected:

On the columns there are “Sales Amount” and “Reseller Sales Amount”:

In the context we have “Road Bikes” selected:

The report shows us the sales amount of road bikes by month of the years 2016 and 2017:

But in case we have 2 measures displayed on the chart it is difficult to analyze how the reseller sales amount change. It would be nice if the summary sales are displayed by line over the bars.

Let us change the way how the “Sales Amount” is displayed. Press the button on the “Sales Amount” control which opens the settings for this measure, as shown on the picture:

Check the box “Override type” and select the line type:

Press the button “Apply”. The chart now looks like this:

You can also display charts for different measures on different panes. In the same settings dialog for “Sales Amount” set the parameter “Display” equal to “On Pane 2”:

Press the button “Apply”. You will get the following chart:

You can display each measure on one of four available panes, or you can also select «Don’t show» option in order to avoid displaying a measure on the chart.

Let us look at the chart where one of the measures displays the percentage growth. Let us select all the months of the year 2016 on rows:

Put the measures “Reseller Sales Amount” and “Reseller Sales Amount Growth%” onto columns:

Put “Road Bikes” into context:

Let us show how to make a separate axis for the measure “Reseller Sales Amount Growth %”:

Put it onto pane 1 (the same pane where the measure “Reseller Sales Amount” is):

Now let us set up the axis:

The chart looks like this:

We have a chart with two measures at once, each measure has its own axis.