Top5

DaniFigueroa

Hi, I wonder how I can get the Top5 of clients from a database.

I wish you could help me. Thank you

BalazsBarany

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

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