I run our Team website and we have a section where players, past and present, can look up stats records. I have separate databases for hitting and pitching statistics. I have it set up where I have one page that is for single season records with several tables, one for each stat category in the hitting database. I copied the hitting data set for that page over and over renaming them to a corresponding stat that they would be used for in a corresponding table. So hits leaders will show up in hits and doubles in doubles, It works great but now I want to do the same thing for career stats. Example…Billy Joe is listed in the hitting database 4 times for the 4 different years he played and say he is our “all-time” hits leader. I want to be able to have table that displays his name and the total number hits he has along with whoever is number two, number three and so on and then do this for each stat. Any ideas? Thank you in advance.
Greetings,
You will want to get acquainted with WixDataAggregate . Once you see how it works, I’m thinking that you will see no need to store the “all-time” results to a collection. You would just display the queried aggregate results in a page at run time, and it would always be based on the latest years entered.
I hope this helps.