Conditional count and addition

Hi all,

I have a custom data type with several fields.
Employees (custom data type)

  • Name
  • City
  • Age
    etc.

I want to count the amount of Employees coming from one city?
Additionally, I want to sum the age of the Employees comming from the city and calculate the average.

How can I make this conditional count and conditional addition?
Thanks

1 Like

I am looking for something very similar… the best association I can think of is the COUNTIFS in excel/sheets, which allows you to count the number of times two different fields appear together in the same record. But not sure how you would do this in Bubble.

1 Like

Hi!

Did you find a way to do this in Bubble? I’m interested too and I’d appreciate your feedback!

Thanks!