1. Overview
2. Concept
| Grammar | same_period(x_agg(array), datepart) | Calculate the same period value based on the date field added by the horizontal and vertical axis or row and column dimensions. |
|---|---|---|
| Parameter1 | x_agg(array) | The first parameter is the indicator used for calculation, which must be an aggregate function or aggregate indicator. |
| Parameter2 | datepart | The second parameter is used to calculate the same day of the year or the same day of the month when configuring the calculation of the same period. When the field dragged on the horizontal and vertical axis does not meet the calculation requirements of the function, the indicator will be marked in red. |
Note 1: The parameters support Y, M, W, and are not case sensitive.
3. Examples
If the user drags the sales date (grouped by year, month, and day) on the horizontal and vertical axis, the calculation result of SAME_PERIOD(SUM_AGG(AMOUNT), "Y") is that the sales are grouped and summarized according to the year, month, and day, and then the data on that day is calculated The sales volume on the same day of the year; if the parameter 2 is "M", the calculation result is the sales volume of that day on the same day of the previous month.
Sample data: "Sales DEMO>FRDemo_ORDERS".
3.1 Calculate the monthly amount for the same period
To calculate the monthly amount for the same period, you need to change the grouping of the date field "SIGNDATE" as "Year Month", as shown in the following figure:
SAME_PERIOD(SUM_AGG(AMOUNT),"Y"), as shown in the figure below:
For the writing of functions, please refer to: Function Calculation Format.
3.2 Effect view
Just drag the calculated indicator into the indicator column, so the value of the same period in June 2009 will show the amount in June 2008. For details, please refer to section 1.2 of this article.
