Say I have a set of timeseries data which is attached to a specific version number, each version of the set of data is then updated on a monthly basis. So,
V1: Jan Feb Mar April May etc
V2: Feb Mar April May etc
V3: Mar April May etc
Now say I want a metric and I want it to show the following timeseries data:
V1_Jan V2_Feb V3_Mar V3_April V3_May etc
What I originally thought you could do was use the following inside the tsDecl in the simple metric
However, when using this what you get instead of the required set above is:
V1_Jan avg(V1_Feb+V2_Feb) avg(V1_Mar+V2_Mar+V3_Mar) etc
So while creating the series it will average out the months which sit in the same date range.
Can I create a treatment that will take the previous value, but when presented with multiple records only gives the most recent version of the months data?