Top 10 customers odoo

query = "select sum(s.amount_total) as total , s.partner_id,
c.name from sale_order as s inner join res_partner as c 
on s.partner_id =c.id  group by s.partner_id,c.name
order by total desc"
//this will return the sum of amount_total group by custmer name ,
//you need to put this value inside the  self.env.cr.execute(query)

Similar codes

45 votes146 views6 answers
Css elipsis
CSS
0 vote119 views1 answer
Css media query aspect ratio
CSS
3 votes119 views1 answer
Font. to be thinner css
CSS
64 votes116 views6 answers
Center image html
CSS
0 vote84 views1 answer
Affect top div opacity without affecting childrne
CSS
1 vote240 views1 answer
Sticky mat-toolbar
CSS
0 vote113 views1 answer
Html align svg to text
CSS
23 votes124 views2 answers
Center align in grid
CSS
0 vote146 views1 answer
Background image animation css codepen
CSS
0 vote138 views1 answer
Crop image instead of resize css
CSS