Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

Top5

Hi, I wonder how I can get the Top5 of clients from a database.

I wish you could help me. Thank you

Find more posts tagged with

AI Studio

Accepted answers

BalazsBaranyRM

Hi!

Usually you can order your clients by the metric you select (e. g. revenue, number of invoices) directly in the database by using ORDER BY.

If not, you can read the whole example set into RapidMiner and use the Sort operator with the selected attribute and sorting direction = decreasing. Then you use "Filter Example Range" with first example = 1 and last example = 5 to only get the top 5.

Regards,
Balázs

All comments

hughesfleming68

@DaniFigueroa. It would be helpful if you could explain what you are trying to do in more detail. Are you trying to read from a database? Is that part working already? Once you have the data in a table, it is just a matter of sorting and filtering example range. It would be helpful to see what your data looks like otherwise it will be very difficult to guide you.

regards,

Alex

BalazsBaranyRM