Chart

To create a chart, you need to click a “Chart” icon in the dashboard designer window on the toolbar:

As a result, a new dashboard element appears:

The left item contains the following chart parameters:

• Values – measure, data is displayed on the Y-axis;
• Argument – dimension, data is displayed on the Х-axis;
• Series – dimension, data that is used to create

In the field on the right there will be a chart itself.

Let us create a chart, which will show the sales volume of product categories by year.

Having filled in the fields as in the picture below, you will get the following chart:

Let us change its type:

A window of the following view will open:

The first tab “Series Type” allows redefining a chart type. Among all the suggested options, let us choose “Full-Stacker Bar”:

A “Common Options” tab offers following possibilities:

• Plot on secondary axis – data is displayed secondary axis
• Ignore empty points – not to display zero values in a chart;
• Show point markers – for a chart of an “Area” type point markers are displayed.

We will not change anything here.

In a “Point Label Options” tab, the following possibilities are available:

• Content:
  • Select All
  • Argument
  • Series Name
  • Value
• Overlapping mode:
  • Hide overlapping labels – hide overlapping labels;
  • None – display all the labels;
  • Reposition overlapping labels – hide overlapping labels regime is off (all the labels without overlapping will be shown).
• Orientation:
  • Default – labels are located horizontally;
  • Rotate to the Right – labels rotation for 90 degrees clockwise;
  • Rotate to the Left – labels rotation for 90 degrees
• Bar options:
  • Show for zero values – to display or not to display zero values;
  • Position – labels position either outside or inside (for Histograms and Bubbles).

Fill out the following tab as shown below:

As a result, the report will have the following view:

Let us add one more data panel:

To the existing chart, we add one more panel that displays the number of orders for all the same product categories by year. For this, drag the “Reseller Order Count” measure to the value bar, select the “Spline” type of the chart and set the following parameters on the remaining tabs:

As a result, we will get the following chart: