Time builder: average of a year compared to the long term average


(Mauro Michielon) #1

Dear all,

I have a data series of numerical observations.
I would like to create a metric with time builder, which shows:
(sum of obsValues filtered for 2018) / (the average of (sum of obsValue by years)) *100

my data layout is:
"date","year","obsValue"
"2011-01-01 00:00:00",2011,55743
complete file in: https://gist.github.com/michimau/d94b9adb23e4b870b1e7534051d3b1af

I am breaking my head around it, but i do not see how it could possibly work.
Any idea if this is possible in the first place?

Best!
M


(Mauro Michielon) #2

no lta?