Aggregation in AppWrite

Can someone show me how to do aggregation with app write. I am using mongodb and I want to know If It possible to use aggregation in app write.

Appwrite doesn't have an aggregation pipeline like MongoDB. This is how you query for documents: https://appwrite.io/docs/databases#querying-documents

That said, we are currently looking into improving the Databases service by adding support for relationships and operations like count, sum, average, etc.

If I have to generate a chart from multiple collection, how will I do it? It doesn't seem to be possoble by looking at the query methods that app write provides.

You would either have to:

1. fetch the necessary data and process it client side
2. maintain helper/metadata collections with some of the data already

Relationships would be awesome 🥵😍

Make sure to check out https://discord.com/channels/564160730845151244/564160731327758347/1078348914048114799