Creating a standings page

Hi,
I’m trying to create a page that would display the standings of a youth baseball organization. I need help with showing the team, wins, losses, runs for, runs against, and winning %. Data is being entered to capture each game result (winning team, losing team, runs) but I don’t know how to take those results and aggregate them together to give the total wins, losses, etc. Thanks for any help.

Hello,

The implementation really depends on your needs.

If you are going to store all the information in a database collection, you can populate it in a repeater or a table .

You could also use dynamic pages for different statistics and forward your site visitor to the one he is interested in using onClick .

Here you can find the related forum post that will help you do it.

Thanks. I need some more help though. I think it would be best to store the data in a collection. So I need to figure out how to calculate the data based on what is already in a collection. Here is what I have - a collection that stores scores which are entered through the front end. This scores have winning team, winning team score, losing team, losing team score, and game date. I need to count up the number of times a team shows as winning team in that collection. The new collection would then be the names of all teams (already in a collection) and then the teams count of wins. I think if I can get some help with figuring that out then I can get the rest (losses, runs scored, runs against). Thanks!