MoM Analysis of Sales & Gross Profit & Gross Margin

  • Last update:October 12, 2024
  • Overview

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

    Example

    MoM Sales Trend Analysis

    Effect Display

    month of month

    Combination Chart Creation

    1. Click the e9764b51687e4f538f5f730f09c790b.png 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 a8eb904f8e1d59f00f337bab722977c.png 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.

    3331455325523411.gif

    Chart Beautification

    1. Click the a8eb904f8e1d59f00f337bab722977c.png 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 a8eb904f8e1d59f00f337bab722977c.png 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.

    33314553255234112.gif

    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

    3c52c78fe6a73f28119b7aa3b504806.png

    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

    0a40790260c02061afbccc7cadc001b.png

    Combination Chart Creation

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

    图片1.png

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

    Chart Beautification

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

    Subsequent Operation

    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.

    附件列表


    主题: Getting Started
    Previous
    Next
    • Helpful
    • Not helpful
    • Only read

    滑鼠選中內容,快速回饋問題

    滑鼠選中存在疑惑的內容,即可快速回饋問題,我們將會跟進處理。

    不再提示

    9s后關閉

    Get
    Help
    Online Support
    Professional technical support is provided to quickly help you solve problems.
    Online support is available from 9:00-12:00 and 13:30-17:30 on weekdays.
    Page Feedback
    You can provide suggestions and feedback for the current web page.
    Pre-Sales Consultation
    Business Consultation
    Business: international@fanruan.com
    Support: support@fanruan.com
    Page Feedback
    *Problem Type
    Cannot be empty
    Problem Description
    0/1000
    Cannot be empty

    Submitted successfully

    Network busy