I have a solution to track basketball player workouts.
I have the Player Table that is connected to a shooting table to track makes and misses in Free Throws in workouts,
Player::_pk_PlayerID=Free Throw Shooting::_fk_PlayerID
I setup another occurrence of Player .... Player2 and set it up Player2::First Name X Player::College,
The Dashboard allows me to list all of my players and information about them.
What I want to do is to be able to Have a portal from the dashboard whenever someone shoots 80% in free throw shooting in a particular day. For Free Throws we always shoot 25, the shots attempted field is a global field that always is set to 25. I can filter the portal to records with 20 or more made shots in a day to pull the record, but I don't know how to get the data to the dashboard as I know I m missing a step somewhere.
The Chart is below