Please can someone tell me whether it is possible to have recursive formulas (expressions) in charts? I want to calculate a measure that depends on the value that comes directly before it (also calculated in the same way). A simple analogy would be a cumulative sum, but this isn't what I am trying to do. It is effectively, an auto-regressive process i.e. 90% based on the previous value and 10% based on a new value derived from another field. I can't do any of this in the loading scripts as it will be dependent on selections.
Is this possible? Any assistance would be greatly appreciated.
You can refer to some other calculated expression in the same chart by using the column(X) function where X is an integer representing the expression column number.
