#Do I need multiple aggregates on same table?

6 messages · Page 1 of 1 (latest)

mighty locust
#

I have a table with lets say 3 fields that I want to aggregate and count on. I know how to do this for one of the fields but if I remember right, an aggregate is a key value pair? so do I have to create 3 aggregates, one for each field and then call their functions individually? or is there by any chance a single aggregate that can build?

thorny sableBOT
#

Thanks for posting in #1088161997662724167.
Reminder: If you have a Convex Pro account, use the Convex Dashboard to file support tickets.

    - Provide context: What are you trying to achieve, what is the end-user interaction, what are you seeing? (full error message, command output, etc.)
    - Use [search.convex.dev](https://search.convex.dev) to search Docs, Stack, and Discord all at once.
    - Additionally, you can post your questions in the Convex Community's #1228095053885476985 channel to receive a response from AI.
    - Avoid tagging staff unless specifically instructed.

    Thank you!
mighty locust
#

Anyone able to help me on this? Just want to make sure I understand the technology, Appreciate it.

atomic oracle
#

sounds like you want three aggregates

#

unless you want to count combinations of particular things

#

but sorry, I'm not sure I have enough context to say exactly what's the right approach -- what sort of product problem you're trying to solve here