Trying to use an aggregate query to count certain records. Now I know that Number type fields cannot be used in
Group By so I'm trying the following:
SELECT Count(Id), Max(Number_Field__c) FROM MyObject__c GROUP BY Text_Field__c HAVING Text_Field__c = 'String Literal' AND Number_Field__c >= 1000000
But I'm still getting an error
[object Object]: HAVING expression must be grouped or aggregated from the Query Editor.