Skip to content

Instantly share code, notes, and snippets.

@atulgupta31
Created October 30, 2015 11:38
Show Gist options
  • Save atulgupta31/34b6b26156fce2bf18a6 to your computer and use it in GitHub Desktop.
Save atulgupta31/34b6b26156fce2bf18a6 to your computer and use it in GitHub Desktop.
public class vfc_apexbarSeries {
public List<AggregateResult> getData() {
return
[SELECT SUM(Amount) monthlyRevenue, COUNT(Name) numOppsClosedWon,
CALENDAR_MONTH(CloseDate) theMonth
FROM Opportunity
WHERE stageName = 'Closed Won' AND CALENDAR_YEAR(CloseDate) = 2011
GROUP BY CALENDAR_MONTH(CloseDate)
ORDER BY CALENDAR_MONTH(CloseDate)];
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment