Yup, this is a limitation of RAG, which is meant for more semantic matches of text, not for aggregation / math type queries. For that you need to use a slightly different mechanism, where you first take the user's query and ask the LLM to convert it into a Typesense query and then run that query against Typesense, and pass those results to the LLM again and ask it to form a response.