Monthly Profit Days Statistics

Background

In addition to viewing the trend of profit changes over time easily, you may want to further observe the impact of seasons on profits.

This article introduces how to calculate profits on a daily basis. You can calculate the number of days with high profits and losses for each month.

Preview

Categorize dates into three types: high profit, loss, and profit.

The chart below shows that November is the peak season with the most high profit days and the least loss days throughout the year.

Adding Data

Example data:

Order Information.xlsx

Create a subject and upload the example data to the subject.

Creating a Component

Calculate the profit for each date, and label each date as high profit, profit, or loss based on the profit amount to make it easier for statistics.

Calculating the Profit for Each Date

Add a calculation indicator to calculate the daily profit.

Note: For details about the function SUM_AGG, see SUM_AGG.

Tagging Each Date

If the daily profit exceeds 2000, label it as High Profit.

If the daily profit is less than 0, label it as Loss.

Add a calculation indicator, the formula is shown in the following figure:

Counting the Number of Days

Add a calculation indicator Number of Days to count the number of days with High profit, Loss, and Profit for each month.

Creating a Line Chart

Select Partitioned Line Chart as Chart Type, and drag the fields into Horizontal Axis, Vertical Axis, and Color.

Select year as the grouping type of the first Order Time, and Month for the second Order Time.

Demonstration