Forums

We are trying to write a query totalling Opportunities (count and eventually revenue, etc) grouping by AbEntry.

I have tried queries similar to the below but the groupby "AbEntry" is ignored. Other fields such as objective do work.

How can we achieve this?

{
opportunity: {
scope: {
fields: {
"AbEntryKey": 1,
"$COUNT()": 1,
"$SUM(corporateRevenue)/displayValue": 1
}
},
groupBy:{
fields:[
"AbEntryKey"
]
}
},
configuration: {
drivers: {
IOpportunitySearcher: "Maximizer.Model.Access.Sql.OpportunitySearcher"
}
}
}