MoM Analysis of Sales & Gross Profit & Gross Margin

After completing data preparation in an analysis subject, you can analyze and visually display the data.

MoM Sales Trend Analysis

Effect Display

Combination Chart Creation

1. Click the  button at the bottom of the page to add a component and drag the field Date into Dimension and Sales into Indicator.

2. Drag the field Sales into Indicator again, click the field, and rename it MoM Sales Growth Rate. Click the  icon on the field and choose Quick Calculation > Comparison with Same Period/Comparison with Previous Period > Growth Rate of Comparison with Previous Period for direct viewing of proportion distribution.

3. Select Custom Chart in Chart Type and set the chart type of the field MoM Sales Growth Rate to Column Chart in Graphic Property.

Chart Beautification

1. Click the  icon on the field MoM Sales Growth Rate, select Set Value Axis from the drop-down list, and set Shared Axis to Right-value Axis. Click the  icon on the field Sales, select Value Format from the drop-down list, and set Quantity Unit to Thousand. For details, see Setting Value Axis in the Chart and Value Format in Table.

2. Set different colors for the column chart of the field MoM Sales Growth Rate based on the magnitude of that field value.

3. Set a cordon to display the 0 value of the field MoM Sales Growth Rate. For details, see Cordon/Trendline Setting in the Chart.

4. Drag the field Sales into Label under Graphic Property > Sales and deselect Display All Legend under Component Style > Legend.

5. Click the component tab at the bottom of the page and rename the component MoM Sales Trend Analysis.

MoM Gross Profit Trend Analysis

Effect Display

Combination Chart Creation

For procedures, see section ''Combination Chart Creation.''

Chart Beautification

For procedures, see section ''Chart Beautification.''

MoM Gross Margin Trend Analysis

Effect Display

Combination Chart Creation

Firstly, you need to add a calculation indicator named Gross Margin. For details, see SUM_AGG.

For further procedures, see section ''Combination Chart Creation.''

Chart Beautification

For procedures, see section ''Chart Beautification.''

After you finish the MoM analysis of sales, gross profit, and gross margin, you can go to Analysis of Regional Store and Product Quadrant for further learning.