Back to forum

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. 
 
 

3 answers

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

zgq456 July 29, 2019

after I choose Running Totals in the pop up window, as the attachement show. I seems what it do is just an accumulate sum.  my case is a little complicated. I’d like to calculate next value based on last value by applying a custom formula. eg: Bn = Bn-1 * (1 + x) . 
can you support this? 

WebDataRocks Team WebDataRocks July 31, 2019

Hello,
Currently, it is not possible to implement such a case with the existing functionality.
Regards,
WebDataRocks Team

Move up