Growth Rate

In the case of sales data and financial data analysis, you can use Growth Rate to analyze year–on–year/month–on–month data.

Setting Procedure

Click Stats, select a data source, and click Combo Chart. Then edit the chart and click Mea.(Right) > Advanced Computing > Growth Rate.

Note:

Analyzing Year-on-Year Data

1. Definition: Year–on–Year (YoY) means comparing the data in one–time point with that in the same point of the previous time range.

For example, when aggregating sales by year–month, you compare the sale in November 2018 with that in November 2017.

2. As the date changes, you may adopt different methods to analyze year–on–year data. You can compare:

For example, you need to compare the profit in February 2022 with that in February 2023. Drag the Sales Volumes field to Mea.(Left), which will be calculated through Sum, and drag the Profit ($) field to Mea.(Right), which will be calculated through Sum–YoY LY.

Analyzing Month–on–Month Data

1. Definition: Month–on–month (MoM) means comparing the data in a time range with that in its neighboring range. For example, you compare the sale in October 2018 with that in November 2018.

2. As the date changes, you may adopt different methods to analyze month–on–month data. You can compare:

For example, you need to compare the profit in April 2023 with that in March 2023. Drag the Sales Volumes field to Mea.(Left), which will be calculated through Sum, and drag the Profit ($) field to Mea.(Right), which will be calculated through Sum–MoM.