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

puchatekkubuspuchatekkubus Member Posts: 2 Contributor I
edited November 2018 in Help


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


  • Options
    Edin_KlapicEdin_Klapic Moderator, Employee, RMResearcher, Member Posts: 299 RM Data Scientist

    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.




  • Options
    puchatekkubuspuchatekkubus Member Posts: 2 Contributor I

    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).



Sign In or Register to comment.