can I add custom formula to web data rocks

Answered

I have a column named daily return, eg: 0, 0.1, 0.2, 0.3… I’d like to calculate accumulative total, base is  1,  next is 1 * (1 + 0.1) = 1.1, 1.1 * (1+0.2) = 1.32, 1.32 * (1+0.3) = 1.716, that is every value is based on previous value.  the attached image is vivid to illustrate my confusion. 
thank you in advance for giving me a hand. 
 
 

1 answer

WebDataRocks Team WebDataRocks July 11, 2019

Hello,

Thank you for writing to us.

We are glad to announce that accumulative total was added as a new aggregation in our latest release. Just update to the latest version and select Running Totals aggregation in the Field List.

Hope it helps.

Regards,
WebDataRocks Team

Please login or Register to Submit Answer