Forum Documentation Showcase Pricing Learn more

Group by in a list

Hi everyone,
I’m actually having an issue, let me explain the case :
I have an element in my DB called “Choice” wich have 2 differents field :

  • ID (text)
  • Result (number)
    I want to make a research of a list of elements in my DB and i want their result but grouped by ID (only 1 value per ID and not per Item). I can make the research but it’s impossible to group by ID and get the result…
    Thanks in advance and have a good evening.
    Robin.

Hi Robin!

If you do a : group by operation after your search, you can specify if the type of aggregation you want (count, sum, average, etc.)

For example, here is a repeating group that group’s by ID and gives the sum of the Result field.

Hope that helps!

–Ken



Looking to accelerate your app development?

Development of Advanced Apps at https://uniqueideas.com or schedule a free intro session :gift:

Ken Truesdale
LinkedIn