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