I’m trying to create a query that will display a sum total of “points” by “team”.
I made a server action query and connected it to a page with a responsive table
When I add SUM in the aggregate the responsive table shows just one line per team entry but no data. If I take the sum away it shows a record for each entry with the points filled in.
This is the first I have tried to build a table that summarizes data so I suspect I’m building it wrong?