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

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

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

Answers

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

     

    Best,

    Edin

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

     

    Regards

Sign In or Register to comment.