| Note |
|---|
| It is recommended to get familiar with dateAt and dateInterval function before proceeding with this tutorial. |
Link relative ratioLink relative ratio refers to comparison between the current data and data of the previous period, for example value of indicator before one month. This can be done in BellaDati with very simple formula: | Code Block |
|---|
| dateAt('now'){M_NUMBER}/dateAt('now-1m'){M_NUMBER} |
If you need to aggregate the value for a period of time, use this formula instead: | Code Block |
|---|
| dateInterval(date('now-1d'), date('now')) {M_NUMBER }/
dateInterval(date('now-1d-1m'), date('now-1m')) {M_NUMBER } |
Year-on-year ComparisonYear-on-year comparison is made between the results for a current period and the same period in the previous year. This can be done in BellaDati with very simple formula: | Code Block |
|---|
| dateAt('now'){M_NUMBER }/dateAt('now-1y'){ M_NUMBER} |
If you need to aggregate the value for a period of time, use this formula instead: | Code Block |
|---|
| dateInterval(date('now-1d'), date('now')) {M_NUMBER }/
dateInterval(date('now-1d-1y'), date('now-1y')) {M_NUMBER } |
|