Options
Result window and pie chart - how to sum and group?
puchatekkubus
Member Posts: 2 Contributor I
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
0
Answers
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:
Hope this helps.
Best,
Edin
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