Add ability to use report level calc fields with Link on View Field feature
We would like the ability to use report level calculated fields as a join when using 'Link on View Field' feature
Though it is possible to create calculated fields via the View and use these as the joins In this particular case I didn't think a view level calc field would work for me as I was effectively trying to get first purchase ID for every customer, for a particular promotion. I suppose a very bespoke field could do it but it would then mean I'd need to do it every time, which I kind of did in the end I suppose but at that stage I was against the clock!
Ideally I'd want to be able to generate this on the fly using the logic of the subquery to narrow down what I needed.