Hi,

I want to write an Analysis tool for our sales department. I use a dashboard and a simple graph, the problem is that we have so much unnecessary data in it. I want to display in a graph the top 20 most sold products, but somehow it isn't possible to limit it. It displays every product in the graph which makes it pointless since you can't read anything from it.

What is the best way to do so in Odoo 14? I already thought about an SQL View in which I limit it within the SQL Query, but this also has some disadvantages to me, so I would be happy for ideas