Hello,
I’m trying to create a report on wealth over time. Let’s say we have stocks and real estate. We have data points for stocks in may, June, July, August and September. We have data points for real estate in May and August.
How can I use the data point for real estate of May in the months of June, July and August? The value of real estate is not zero in these months.
Appreciate any help or ideas!
Thanks, Nicolas
I assume you meant ‘in the months of June and July’ (since you have a value for August).
Did you want the values for June and July to be the same as the value for May?
Or did you want to have true interpolation, i.e. the value in June would be 1/3 of the way between the May and August values, and the July value would be 2/3 of the way between the May and August values?
Sorry, you’re right, June and July. Thank you!
For June and July, the best solution would be 1/3 and 2/3, so in my example
May: 300
June: 266
July: 233
August: 200
If that’s not possible, the next best thing would be
May: 300
June: 300
July: 300
August: 200
And, just to go all around, in September take the value of the last entry, i.e. 200
Does that make sense?
Unfortunately, I don’t think this is possible. I think the only workaround would be to (perhaps automatically) create entities to represent the intermediate/extrapolated data points.
Okay, not the hoped-for-answer, but it brings clarity. Thanks for your help!
