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
How can we perform a % calculation in a dataset
Learner I
I have the following dataset...need to calculate the percentage. Given below is a sample data set. The positive survey count, negative survey count & CSAT% are numerals.
The formula is ""positive survey count" / ("positive survey count" + "negative survey count")"
The formula is ""positive survey count" / ("positive survey count" + "negative survey count")"
| Employee | positive survey count | negative survey count | CSAT% |
| EMP1 | 3 | 2 | ? |
| EMP2 | 5 | 1 | ? |
| EMP3 | 3 | 3 | ? |
| EMP4 | 7 | 2 | ? |
0
Answers
you can use the Generate Attribute operator. Is very useful and easy to work and you can introduce your own formula to calcúlate a new attribute.
https://academy.rapidminer.com/learn/video/generate-attributes
Best,
Cesar
thank you for the help. Tried the solution. Still unclear...are there more direct examples?
Regards,
Rajat
please find attached a simple sample process with your data.
best,
Cesar