Finding Average Value From User Specific Repeatable Forms
I am stuck in finding a solution to a math problem. I have a form with a repeatable section, inside this repeatable section I have a field (let's call it Field Goal Yards) that asks the user to enter a number of how many yards kicked in a year.
Because this is a repeatable section the user can have just one entry (for one year) multiple entries (year 2, year 3, year 4 etc) depending how many times he or she repeats this section. I am trying to display the lifetime average for this particular user, but I am getting the wrong answer.
I am using [frm-stats id=2857 type=average] to display the average but this is giving me the average of ALL the users who entered yardage in this field. I just want to display the career average yardage for a particular user.
Testing this out "User A" has entered 15 and 22. User B has entered 6 and 5.
Using [frm-stats id=2857 type=average] will show 12 as the answer (15+22+6+5=48 / 4 = 12) which is wrong.
It should be for "User A", 18.5 (15+22=37/2=18.5) And for "User B", 5.5 (6+5=11/2=5.5)
How can I get the correct average amount per user specific?