GROWTH functions for indicators
Hi, I'm computing for change in metrics from period to period. For example, what's the pct change in sales from 2022 to 2023. Question 1: If data is only available until March 23 2023, will Grow...
Forum Discussion
Hi there!
1. I assume this question is about the Growth() function.
This depends on the way you create your widget and set the date dimension. For example, if the date dimension on the widget is Year then the data from year 2023 (so, from the 1st of Jan 2023 to the 23rd of March 2023 in this case) will be compared to the whole data from 2022.
If the date dimension is set to month, then April 2023 won't have data to compare, March 2023 will be compared to February 2023; Feb 2023 to Jan 2023; Jan 2023 to Dec 2022, etc.
2. Could you please provide an example of the results you get and the results you expect to get?
It's important to remember that GROWTHPASTYEAR will calculate the growth from the previous year for the time resolution defined in the widget. So, for example, if the time resolution is set to Month, the GROWTHPASTYEAR will compare March 2023 to March 2022; if it is set to Day, then it will compare the 23rd of March 2023 to the 23rd of March 2022, etc.
Best Regards,
Volodymyr
