Result window and pie chart - how to sum and group?

puchatekkubus

Hi,

I'm new to RapidMiner. First thing I want to do is to obtain pie chart from simple dataset.

In MySQL table I have columns: client_id; turnover (several records for each client).

 

I add "Read Database" component, run the process, on the "chart" window I select "chart style" pie and if I choose "group-by column" klient_id it does not work (no data available).

 

What should I do to sum "turnover" column and group by "client_id"?

Thanks for help

Edin_Klapic

Hi puchatekkubus,

 

welcome to the RapidMiner Community! Great to have you here

 

I recommend to use the Operator Aggregate right after Read Database. There you should Group by client_id and Aggregate the turnover as sum. Please be sure that your turnover Attribute is numerical!

 

Afterwards the settings for the Pie chart should be:

• Group-By: None
• Legend: client_id
• Value: sum(turnover)
• Aggregation: none

Hope this helps.

 

Best,

Edin