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

0 vote307 views1 answer
What css vmin
CSS
0 vote324 views1 answer
Responsive font size with clamp
CSS
0 vote332 views1 answer
Css aplying everything
CSS
0 vote365 views1 answer
Chai assert
CSS
1 vote336 views1 answer
Css flip svg
CSS
4 votes302 views1 answer
Grid repeating auto columns
CSS
-1 vote323 views1 answer
Input focus css default
CSS
1 vote343 views1 answer
Mini-css-extract-plugin
CSS
0 vote320 views1 answer
Overwrite safari dropdown css
CSS
0 vote351 views1 answer
Div with specific id css
CSS