How can we perform a % calculation in a dataset

rajatdas

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")"

Employee	positive survey count	negative survey count	CSAT%
EMP1	3	2	?
EMP2	5	1	?
EMP3	3	3	?
EMP4	7	2	?

Caperez

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, 

Cesar