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 

rajatdas

Hi Perez,

thank you for the help. Tried the solution. Still unclear...are there more direct examples?

Regards,
Rajat

Caperez

Hello @rajatdas, 
please find attached a simple sample process with your data.
best, 
Cesar