Non-grouped query that uses overall aggregate issue in skuid

I am on the same team as Vijay (the OP). The issue is that we are not getting this error in our development sandbox, but when we move the Skuid pages to a production SFDC org - this error appears. Any suggestions on what to look for to sort this out would be appreciated!

Aggregate queries don’t play well with Limits.  This is a known issue in Skuid.  We encourage you to remove limits in these models.  But what probably happened is that in your sandbox you didn’t have the volume of data required to trigger the issue  - ie you didn’t exceed the limit.   Whereas in Prod, you did…

Rob - Actually, it is the opposite. We have a fair amount of data in our development sandbox and literally zero data in production since we haven’t gone live yet. That said, thank you for your post and we’ll remove the aggregate queries with limits. Andy

Let us know if this problem persists.