Top Opportunities

Dynamics CRM

 

Dynamics CRM is a widely used cloud CRM from Microsoft, focused on Sales, Marketing, and Service (help desk) sectors.

This chart takes the user's list of open opportunities and select the top 10 based on the estimated revenue

Query Text

SELECT 
    o."name" 'Topic', o."estimatedvalue" 'Est. Revenue'
 FROM 
    "opportunity" o
 INNER JOIN 
    "owner" AS owner_o ON o."ownerid" = owner_o."ownerid"
 WHERE 
    o."statecode"='Open' AND owner_o."name" = 'Devart Corp' 
 ORDER BY 
    o."estimatedvalue" desc
 LIMIT 10
  

Open Query