The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here

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

puchatekkubuspuchatekkubus Member Posts: 2 Learner II
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 Employee-RapidMiner, 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 Learner II

    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.