Stuck Opportunities

Salesforce

 

Salesforce is the most popular cloud CRM with a focus on sales and support.

Where are the opportunities getting stucked ?

Query Text

SELECT Owner.Name AS "Opportunity Owner", Account.Name AS "Account Name", Opportunity.Name, Opportunity.StageName, Opportunity.Fiscal, Opportunity.Probability, Opportunity.CloseDate, Opportunity.Type, Opportunity.Amount
  FROM Opportunity
INNER JOIN User AS Owner ON Opportunity.OwnerId = Owner.Id
LEFT OUTER JOIN Account ON Opportunity.AccountId = Account.Id
WHERE (date(date(Opportunity.CloseDate), 'start of year') = date('now', 'localtime', 'start of year') AND Opportunity.IsClosed = False)
ORDER BY Opportunity.StageName, Opportunity.Fiscal
  

Open Query