WixDataAggregate.Group() not working as expected with 3 values

Ask the community
,
1

Hi,
Need to get a table with Results by Player / Category / Gross Score. This is for a Golf League we maintained.
While using .Group is not get the latest score by Player/Category. Instead get the score for each by each event within the Player/Category.

If I removed the category then I get the last Gross Score by player with the last eventID.
I changed the approach to put a filter by each category and it works, but would like to have the results displayed using just one table.

Any ideas would help?

Here is how I call the aggreate function:

wixData.aggregate("ScorePlayers")
  .filter(filter)
  .group("player_name","eventId", "category_name")
  .max("gross_score", "gross_score" )    
  .ascending("gross_score")
  .limit(1000)
  .run()
  .then((results) => {

2

Looks good, however a Wix expert may know better how to make it work.