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
-
Hello @rajatdas,
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,
Cesar0 -
Hi Perez,
thank you for the help. Tried the solution. Still unclear...are there more direct examples?
Regards,
Rajat0 -
0
Unicorn