Multiple "Group by"

Ask for Help
2

What exact “bugs” were you facing?

You can sort of do a “unique” setup in Glide.

  • Create a rowID column for the first table.
  • Create a relation from the Store column to itself, make it a multiple match.
  • Create a single value column on top of the relation above, returning the rowID from the first match.
  • Create a rollup column on top of the relation to count the number of orders.
  • Show the inline list of the first table, filter by rowID is the same as the “first match” rowID in step 3. Display the count from step 4.
2 Likes