05-18-2017 04:34 AM
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
05-18-2017 05:16 AM
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.