🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

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