Analysis of Sales Gap

Background

You want to compare the value of a category with other categories.

For example, you want to calculate the sales gap between children's ornament and other categories.

Preview

Select Children's ornament in the filter component, and you can see the sales gap between children's ornament and other categories displayed in the right chart.

Adding Data

Create a subject and find the built-in data table named Store sales statistics in Public Data.

Creating Components

Formula: sales gap = sales of other categories - sales of the chosen category

1.     Adding a Parameter

You need to add a parameter named Chosen Category, so that you can choose a category in the filter component.

2.     Calculating the Sales of Chosen Category

Add a calculation indicator to calculate the sales of chosen category.

3.     Calculating the Sales Gap

Formula: the sales gap = each category's sales - the sales of the chosen category

Add a calculation field like this:

4.     Making a Column Chart

Set the chart type as Partitioned Column Chart, and drag in fields like this:

Drag the fields Sales Volume and Sales Gap to Label, and modify their number format into Ten Thousand.

Making a Dashboard

1.     Adding Components

a. Go to the dashboard editing interface, and drag the created component.

b. Drag the filter component to the interface.

2.     Editing the Text List Component

a. Add the binding parameter Chosen Category to the component.

b. There are two ways of adding options for selection.

• Click Custom Value List to allow manual input.

• Add fields from other tables. For example, your options have to be confined to the Category description field, which can be also found in the table named Retail_Category Dimension. Therefore, you can use the Category description field of that table for selection.

Effect Display

For details, see section "Preview".