Limiting dataset size

How to limit

Check “Limit result to” and select the number of rows you want to keep in the dataset :

Why limit ?

Checking this option with “Limit result to 10 rows” for example will apply a “TOP 10” to the query.
When widgets are sorting the data, this can be a useful to display the 10 Items with the worst performance, or the 10 equipments with the highest consumption for example.