{{fscript "Today's date minus 30 days" start := (NSDate date) mcDateByAddingDays:-30. end := NSDate date. dates := MCReportDateEnumerator allDailyDatesBetween:start end:end. opps := {}. contacts := {}. orgs := {}. labels := {}. dates do:[:date | begin := date mcDateAsBeginningOfDay. endDay := date mcDateAsEndOfDay. labels add:(date mcDayOfMonth). o := objectContext resultCountForEntityNamed:'Opportunity' qualifierLocum:'createDate >= $start and createDate <= $end' bindings:#{'start' -> begin, 'end' -> endDay}. opps add:o. c := objectContext resultCountForEntityNamed:'Contact' qualifierLocum:'createDate >= $start and createDate <= $end' bindings:#{'start' -> begin, 'end' -> endDay}. contacts add:c. org := objectContext resultCountForEntityNamed:'Organization' qualifierLocum:'createDate >= $start and createDate <= $end' bindings:#{'start' -> begin, 'end' -> endDay}. orgs add:org. ]. globals setLabels:labels JSONRepresentation. globals setContacts:contacts JSONRepresentation. globals setOpportunities:opps JSONRepresentation. globals setOrganizations:orgs JSONRepresentation. }}
{{localize 'Compare the creation ratio of opportunities to people to companies.'}}
  Companies    People    Opportunities