The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here
Running total column and RSQ
cliftonarms
Member Posts: 32 
Contributor II
I am a little stuck and would appreciate guidance from anyone who can help.
1) is it possible to create a column in a dataset that is a running total of another column. ie in excel the column cells would be B2=B1+A2 and B3=B2+A3 .... etc etc
2) Is it possible to get the RSQ ( fitness to line ) value for a column.
Both of these are fairly simple in Excel, but I am having trouble doing them within Rapidminer.
Thank you in advance
1) is it possible to create a column in a dataset that is a running total of another column. ie in excel the column cells would be B2=B1+A2 and B3=B2+A3 .... etc etc
2) Is it possible to get the RSQ ( fitness to line ) value for a column.
Both of these are fairly simple in Excel, but I am having trouble doing them within Rapidminer.
Thank you in advance
0
Answers
To answer the first question, you could use operators in the time series extension such as Lag and Differentiate. There are some examples here...
http://rapid-i.com/rapidforum/index.php/topic,6916.0.html
The second question looks like it would require some calculations using macros and the Generate Attributes operator.
So the summary is yes it will be possible but you may have to invest some time.
Regards
Andrew