Advertisement
Guest User

Untitled

a guest
Aug 31st, 2016
61
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.50 KB | None | 0 0
  1. public List<AggregateResult> getChartData() {
  2.  
  3. List<AggregateResult> tw = [SELECT AVG(Engagement_Delta__c) delta, Day__c FROM Engagement_Delta__c WHERE Execution_Date__c = THIS_WEEK GROUP BY Day__c];
  4. List<AggregateResult> lw = [SELECT AVG(Engagement_Delta__c) delta, Day__c FROM Engagement_Delta__c WHERE Execution_Date__c = LAST_WEEK GROUP BY Day__c];
  5.  
  6. List<AggregateResult> MasterList = new List<AggregateResult>();
  7.  
  8. MasterList.addall(tw); MasterList.addall(lw);
  9. return MasterList;
  10. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement