The community member is having an issue with SQLAlchemy, where it is currently counting the records in a query when they need it to sum the values of specific fields. For example, when asking "How many people left my page yesterday?", it uses a count on the records, whereas the question "How many people total left my page yesterday?" returns the correct sum query. The community member has a specific example of this issue but it is being ignored.
Does anyone familiar with sqlalchemy know how to tell it to use a specific queries? It is currently counting the records in a query when it should be summing the values of specific fields.
For context, currently when I ask it How many people left my page yesterday? It uses a count on the records, whereas the question How many people total left my page yesterday? returns the correct sum query