hello everyone
I have a table that holds this information
| Date | Player | Goal(s) |
|---|
| 01/01/2018 | Ronaldo | 1 |
| 09/01/2018 | Messi | 1 |
| 19/01/2018 | Ronaldo | 0 |
| 09/02/2018 | Ronaldo | 3 |
| 10/03/2018 | Ronaldo | 0 |
I need to calculate Ronaldo scoring rate as the time increase
As at 01/01/2018 to 01/01/2018
Ronaldo scoring ratio is 100% since one goal in one match
between the period 01/01/2016 to 10/03/2018 His ratio is 75% (3/4)
How can I make it a dynamic system?
Regards
