Tabular display from filtered data

[rbjames]

I'm recording data from a sports day in the following format (with example data):

Name             Year Group       Group        Number of Points

Student 1         3                      Group 1            8

Student 2         3                      Group 2            7

Student 3         3                      Group 1            6

Student 4         4                      Group 2            8

etc.

I'd like to show a table in the following format:

Year Group              Group              Total points

3                              Group 1                14

                                Group 2                 7

4                              Group 1

                                Group 2                 8

How would I best achieve this?

Thank you in advance.

[Drrickryp · Accepted solution]

@rbjames 

There is an example of exactly what you want to do in the GroupBy documentation here:  https://docs.microsoft.com/en-us/power-apps/maker/canvas-apps/functions/function-groupby  In particular see the part about using GroupBy() and aggregate functions.  

[rbjames]

Thanks - so the best way is to get the data into a collection and display that way? As the data will be changing throughout the afternoon is there a simple way to update the collection with the latest data?

[rbjames]

OK I've got the data to now display how I want it in a table. I have two remaining things to do. Firstly, I'd like a button that can be pressed to retrieve the latest data (or a timer to refresh the data once a minute) - is there an easy command for that?

Lastly, I'd like to put in a column chart to display the results for the 4 groups. I have choices:

1. Create a collection based on summed results

2. Pull the summed data direct from the sharepoint list. 

I know the second one would be one less step. Currently I have a gallery for each of the 4 groups with each filtering slightly differently. What do you suggest? I'll carry on looking through youtube in the meantime.

Thank you.