2 Replies Latest reply on Dec 7, 2018 5:16 PM by Kevin Steenburg

Moving Calculation With Multiple Names/Dates

Hi everyone, I have a bit of a twofold challenge here.  I have performance based data (Performer, Date, Attempt Total, Success Total).  I want to compare each individual success rate (Success / Attempt per month), but because they started at different dates, I am normalizing their time period.  So I want to look at it as Month 1, Month 2,, Month 3....etc.  I want to also do the comparison as a 3 month moving average as a %.

What I have done:

1) Created an Index() calculation --> Using Performer, Month of Date, at the Deepest Level, Restarting every performer, Sort Order by Date, Minimum

2) Created a Success Rate field (Total Success by Performer/Attempts)

3) Added the calculated field to my view, and edit the calculation to Moving Calculation --> Average Prev 2 Include Current --> Using Performer, Month of Date --> Sort Order by Date, Minimum

This works properly when I filter to just one Performer.  However when I add other names, they look like they make sense but the person at the top of my list changes values for some reason.

• 1. Re: Moving Calculation With Multiple Names/Dates

Hi Kevin,

Find my approach as reference below and stored in attached workbook version 10.5 located in the original thread.

1. Score: [Succesful]/[Total]

2. Rank: rank(attr([Date]),'asc')

3. Average: window_avg(sum([Score]),0,3)

4. Drag the required objects to the indicated loations and set rank to discrete and show Performer Filter

Hope it helps

Regards,

Norbert

• 2. Re: Moving Calculation With Multiple Names/Dates

Hi Norbert! Thank you for the response.  I would say this gets me 99% of the way there!  When I do it exactly the way you have laid out, I get the same result, however this result is based on Exact Date and I am trying to do it on Month.  I apologize.  When I apply to Month, I get a lot of nulls and every so often a date gets ranked (keep in mind I have tried this the way I have copied, as well as using the restart every performer option).