RapidMiner

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

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

2 REPLIES
Highlighted
RM Staff
RM Staff

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

Hi puchatekkubus,

 

welcome to the RapidMiner Community! Great to have you here Smiley Happy

 

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

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

Thank you very much indeed for help!

 

It works :-)

 

However I do not get why Group-By is  None.... should be client_id (looks like this parameter is never working).

 

Regards

Polls
How can RapidMiner increase participation in our new competitions?
Twitter Feed