Forum Discussion
calc a rolling rate
Here I am trying to calc a rate that measures soccer player efficiency. I simple measure to compare players.
like this ( goals + ( assists * .5) ) *60 / minutes played. This mirrors the formula in my real data set.
Lets go through testGoalAssist the dashboard.
Page 1: contains monthly measures taking into account the slicers. All good here
Rolling I: created measures the accumulate over the months
As currently set, accumulate the goals , assists and minutes played for Mar 2022 - June 2022.
This works. Viz in the lower left contains the correct results. All good here.
Next I want to roll the efficiency measure over the months like this:
( sum goals over the months + ( sum assists over the months * .5) ) *60
divided by
sum minutes played over the months
Rolling II: looking at the viz Top center
effectiveRateOverPeriods A : returns the expected results .
effectiveRateOverPeriods: is wrong. Not returning what I expect.
do not understand what it is doing. Not the returning my formula above.
Refering to the spreadsheet: goals_assists_mar_june at the top you can find
a spreadsheet showing what I expect
There are links to to G Drive below.
I cannot explain what is going on here. It is beyod me.
Many thanks for your assistance.
KD
please check the link, it asks for access
- KBD1 year ago
Helper III
My apologies thanks for pointing that out.
Should be working now
KBD
- lbendlin1 year ago
Super User
Might be enough to use the average rather than the sum?
G = goals
A = assists
M = minutes
E = average efficiency
- KBD1 year ago
Helper III
No the data and formula are a mock up for a specific use case involving sensitive data and regulated reporting.
So, there is no wiggle room in the formula.
KD