YoY/MoM Growth (Quick Calculation)

Application Scenarios

FineBI offers Year-on-year/Month-on-month, allowing for quick calculation.

Note: This function cannot be used in detail table.

Definition

Once you drag and drop the required fields to Dimensions, you can employ Quick Calculation for fields in Indicators.

If there is a Date field in Dimensions of the analyzing area, the calculation types supported by date groups are as follows:

Year-on-Year

Note: The fields in Dimensions needs to be Date type such as year-month-day, year-week numbers, year-month, and year-quarter.

For example:

YOY: Provided that the sales in August 2020 are known. Then the sales in August 2019 are its YOY data.

MOM: Provided that the sales on July 28th are known. Then the sales on June 28th are its MOM data.

WOW: Provided that the sales on Thursday of this week are known. Then the sales on last Thursday are its WOW data.

The example uses data in Contract form to calculate YOY data for each quarter.

Drag and drop Contract Signing Time into Dimensions and change its group to Year Quarter. For easier comparison, drag and drop two Contract Amount fields into the Indicators and calculate the YOY value for the second Contract Amount field.

Note: Calculating YOY values means to calculate the value of the same time in the previous time period. The YOY values are different in different time groups. If the group is Year-Month, then the YOY value is data from the same month in the previous year. If the group is Year Month Day, then the YOY value is data from the same day in the previous year.

If you drag and drop the Contract Signing Time field into the Dimensions and group it as Year Month Day, you can set the YOY value as Year, Quarter, Month, or Week. For example, set Month as a period to calculate the YOY value as follows:

How to use functions to calculate year-on-year values:

Use formula SAME_PERIOD(SUM_AGG(contract amount),"Y").

Year-on-Year Growth

Note: The fields in Dimensions needs to be Date type such as year-month-day, year-week numbers, year-month, and year-quarter.

For example:

YOY growth: The sales in August 2020 – the sales in August 2019 = the YOY growth

The example uses data in the Contract form to calculate the YOY growth for each quarter.

Drag and drop the Contract Signing Time field into Dimensions and change its group to Year Quarter. For easier comparison, drag two Contract Amount fields into Indicators and calculate the YOY growth for the second Contract Amount field.

Year-on-Year Growth Rate

Note: The fields in Dimensions needs to be Date type such as year-month-day, year-week numbers, year-month, and year-quarter.

YOY growth rate = (current period value - same period value) / same period value * 100% = YOY growth / same period value * 100%

1. Click  > Quick Calculation > Year-on-year/Month-on-month > Year-on-year growth rate > year.

2. Taking the YOY growth rate in Q1 of 2014 as an example. YOY growth rate = (13550907 – 15494300) / 15494300 * 100%

If you only needs the YOY data in 2014 (the same applying to MOM), you can use the filter.

Month-on-Month

Note: The field in Dimensions needs to be Date type such as year-month-day, year-week numbers, year-month, year-quarter, and year.

Calculating MOM values means to calculate the value of the previous period relative to the current time granularity. For example, the values corresponding to the day before today and the month before this month are both MOM values.

Drag and drop the Contract Signing Time field into Dimensions and change its group to Year-Month. Hover your cursor over the Contract Amount field and click  > Quick Calculation > Year-on-year/Month-on-month > Month-on-Month.

The MOM value of 2013-02 is the contract amount value of 2013-01.

How to use functions to calculate MOM value:

Use the formula PREVIOUS_PERIOD(contract amount).

Month-on-Month Growth

Note: The field in Dimensions needs to be Date type such as year-month-day, year-week numbers, year-month, year-quarter, and year.

Drag and drop the Contract Signing Time field into Dimensions and change its group to Year Quarter. Hover your cursor over the Contract Amount field and click  > Quick Calculation > Year-on-Year/Month-on-month > Chain growth value.

Month-on-Month Growth Rate

Note: The field in Dimensions needs to be Date type such as year-month-day, year-week numbers, year-month, year-quarter, and year.

MOM growth rate = (current value – MOM value) / MOM value * 100% = MOM growth / MOM value * 100%

Drag and drop the Contract Signing Time field into Dimensions and change its group to Year Quarter. Hover your cursor over the Contract Amount value and click  > Quick Calculation > Year-on-Year/Month-on-month > Chain growth rate.

Take the MOM growth rate of Q1 2014 as an example. MOM growth rate = (13550907 – 9382307) / 9382307 * 100%

Custom YOY/MOM

When there is no Date fields in Dimensions) while the area to be analyzed has a Date field, you can calculate contrast value, growth, and growth rate quickly through Custom_Period.

For example, calculate the growth  of the contract amount for different contract types in January 2014 relative to that in March 2014.

Notes on Empty Value Calculation

In the calculation of YOY/MOM, if the previous period value or the current period value is empty, the corresponding calculation results of YOY and MOM (including growth and growth rate) will be displayed as empty when calculating the current period value and the previous period value.