Scatter Chart

In order to create a scatter chart click a “Scatter Chart” icon in “Dashboard Designer” window toolbar:

An empty scatter chart will appear:

A scatter chart contains the following fields:

• “Х”-axis – contains the data item against which the X-coordinates of data points are calculated;
• “Y”-axis – contains the data item against which the Y-coordinates of data points are calculated;
• Weight – contains the data item whose values are used to calculate the weight of data points;
• Arguments – contains data items providing scatter chart arguments that are used to create data points.

Let us build a scatter that will display the values of the “Sales Amount” measure and “Gross Profit Margin” measure for product categories, and the size of the circle will correspond to the value of the “Gross Profit” measure.

To do this, drag the “Sales Amount” measure to the “X”-axis, “Gross Profit Margin” measure to the “Y”-axis , “Gross Profit” to the “Weight” field, and drop the “Category” hierarchy into the argument:

By default, a scatter chart does not contain the elements coloring. In order to color the elements, you need to select “Hue” from the drop-down list by right-clicking the “Category” hierarchy in the context menu:

As a result, a scatter chart will have the following view:

Let us find out which subcategories of products of the “Bikes” category gave such a high profit. To do this, select the “Subcategory” hierarchy in the argument field, and enable the “Drill Down” in the “Data” tab:

By clicking the “Bikes” product category, we will see the number of product subcategories that it includes, and the corresponding measures values for them:

Let us turn “Hue” on for subcategories as well:

After that, a scatter chart will get back to its initial view. However, after clicking “Bikes” product category again, we will get the following view of a scatter chart:

To return to the previous detail level (drill up), use the Drill Up button (the  icon).