Link Relative Ratio and Year-on-year Comparison

Link relative ratio

Link 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:

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:

dateInterval(date('now-1d'), date('now')) {M_NUMBER }/
dateInterval(date('now-1d-1m'), date('now-1m')) {M_NUMBER }

Year-on-year Comparison

Year-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:

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:

dateInterval(date('now-1d'), date('now')) {M_NUMBER }/
dateInterval(date('now-1d-1y'), date('now-1y')) {M_NUMBER }