2 Replies Latest reply on Jun 26, 2014 9:04 AM by Aaron Clancy

# Using moving average within a window average?

Hi all,

In the attached workbook you can see that I am using the window_avg formula to segment people into quartiles based on gross profit per hour and orders per hour (two separate sheets). I'd like to come up with a way for the quartile rank to be based on the performance of the last 7 days, a moving average of sorts. I'd also like to be able to click on the column for the A group and see the individual performance of the underlying A people. The last, but maybe most important obstacle I'm facing is plotting these results on a line graph over time, in other words tracking the A,B,C & D groups order per hour on a daily basis over time.

In summary I have the following three questions.

1.) How to use performance of past 7 days to determine A, B, C & D groups

2.) How to show the individual performance of the underlying people within one group

3.) Plotting these results on a line graph over time (FYI - On any given day the "A" people would be based on the performance of the last 7 days, meaning that the "A" people may be a different group of people today than it was a week ago. If you feel that my description of this question is unclear, you are not alone, I also feel that way. Apologies)

Aaron Clancy - the help you offered on my last question was phenomenally helpful. If you get a chance I would love to get your perspective on how to address these new problems.

Greatly appreciate any help I can get on this.

Best,

Sam

• ###### 1. Re: Using moving average within a window average?

Edit*

Lost my work, rebuilding now :-)

• ###### 2. Re: Using moving average within a window average?

Thanks I actually pulled the post off because I lost my "Tableau" work while making some last minute logic changes.  After making the changes I realized there was one more thing I needed to account for that is kind of throwing a wrench in the solution.

The problem is that the ordering of the agent within each grouping cannot be a table calc, which, with the new requirements, will be very difficult if not impossible.