Periodical metrics


Say you have a simple calculated metric like Turnover that is a sum of transaction values. Is there a simple way to have this metrics calculated for periods like month-to-date, year-to-date, trailing 12 months etc. ? The way I do it is with a Native Query where I select the data I want with SQL to do the calculation on, but it's a very repetitive task as I have a lot of metrics and a lot of periods I want to follow. It would be nice to have a way to define a metric and be able to have it calculated on various hardcoded periods that must be the same for all companies (MTD, YTD, 1y, last month, last year etc.)

Hi @AnatoleC
Sounds like you just want to use the filter "Current", which you can set to Month or Year. And "Past" for 12 Months.