I have an interesting question regarding an calculation in the front end. I don't know if this is possible in the front end. I know this can be done in the backend with the Peek function but I need the analytics dynamically cause of the select-able dimension.
Here is the dataset. Exponential weighted moving average (EWMA) Is de formula: First record is value (starting point). The second EWMA record = 0.2*Value+0.8*previous EWMA