Solved

Running Average in Pivot Table/Chart

Posted on 2011-02-22
6
2,774 Views
Last Modified: 2012-05-11
Can anybody tell me if there is a way to construct/display a running average in a pivot table/chart.
I am trying to show the time it takes to close a ticket and would like to display the running average to show if the average closure time is going up or down.
Any help is appreciated.
0
Comment
Question by:greentatertot1970
  • 4
  • 2
6 Comments
 
LVL 41

Expert Comment

by:dlmille
ID: 34954490
You need to create as Pivot Field (Calculated Field) to do that to avoid creating averages of averages.  I believe you want weighted average?

Here's a couple online tips.  If you load a non-confidential spreadsheet, I'll show you how to build it in, if further assistance is required:

http://www.mrexcel.com/forum/showthread.php?t=30526 

http://excel.tips.net/Pages/T002900_Weighted_Averages_in_a_PivotTable.html

Again, if you're going down a different path - upload a sample we can work it no problem.

Dave
0
 
LVL 41

Expert Comment

by:dlmille
ID: 34954535
I may have misread.  Let me work up an example which may be more in line to your query.

Dave
0
 
LVL 41

Expert Comment

by:dlmille
ID: 34954586
Yes - perhaps the solution is simpler than I initially thought.  I created a sample dataset with random start/end dates, then fixed those.  I then created a running average column which I pivoted and trended.

Is this going the direct you're looking for?

Dave sampleRunning-Average-Pivot-r1.xls
0
Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

 
LVL 41

Accepted Solution

by:
dlmille earned 500 total points
ID: 34954718
It doesn't appear Pivot Tables support MOVING AVERAGES, again, this can be something generated to the SIDE of the  Pivot Table.

http://chandoo.org/wp/2009/04/28/calculate-moving-average/  Provides an example if you read down the posts.


Dave
0
 

Author Comment

by:greentatertot1970
ID: 34954732
Yes... this looks like the direction I am wanting to take. I'll look at what you have provided. Thank you!
0
 

Author Closing Comment

by:greentatertot1970
ID: 35017574
Thanks Dave!
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question