mpmX Help Documentation

 

Here we will create a bar chart with the five most important customers. A bar chart is suitable for comparing several values. The dimension axis shows the category items that are being compared; the measure axis shows the value for each category item. Grouping and stacking the bars makes it easy to display grouped data.

 

Proceed as follows:

1.Click the + icon below the measure pointer chart to add a new visualization.

2.Add Customer as the dimension and Sales as the measure.

3.The automatic chart creates a bar chart. You can customize this chart later in advanced edit mode.

 

Customizing the charts in advanced edit mode

Once all visualizations have been created, switch to advanced editing mode to customize them. Activate Advanced options at the top right.

Dashboard - Advanced Options

 

Edit Bar Chart

 

Proceed as follows:

1.Select the bar chart and deactivate Chart suggestions.

2.Under Presentation, select the Horizontal option.

3.Select Data and click on the Customer dimension.

4.In the Restriction drop-down menu, select Fixed number. Enter the following in the formula field: 5.

5.Clear the Show others check box.

6.Click on the chart and add a title: Top 5 Customers

 

The bar chart is ready and shows the five most important customers. If you make selections in other visualizations, the customers will change accordingly.

 

If you had not deactivated the Show others selection, the fifth bar would have been displayed in gray and would have summarized all those sales values where the company name is missing. This value can be helpful to find out how much of the turnover cannot be related to a specific company.