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

User: "puchatekkubus"
puchatekkubus
New Altair Community Member
Updated by Jocelyn

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

Find more posts tagged with

AI Studio
Sort by:
1 - 2 of 21
    User: "Edin_Klapic"
    Edin_Klapic
    New Altair Community Member

    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

    User: "puchatekkubus"
    puchatekkubus
    New Altair Community Member
    OP

    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

Quick Links