Firstly, is my first_cr formula the most efficient formula possible to get the first 'cr' value within a filtered time range of the dataset?
Secondly, I now need to find the 'cumulative return' of a particular dimension to use it as a benchmark in other visualisations or formula. I tried using the above calculated measures in various methods, but either there were no values or the visualisation did not respect the date filter due to some reason.
Eventually, I was able to get the following formula working, which is essentially recalculating everything. Can the above and below formulas be simplified further?
I'd also appreciate a comment on whether my first_cr formula or the method I am using to calculate a metric as percent of the first/earliest metric value in a date range is the best that it can be, or is a more efficient formula possible.