Hello everyone,
I have a case where I need to calculate average number of processed orders within specific time interval.
I have 29500 entries within 2 years. What I need is to find what is the average number of orders that were processed between 7-8; 8-9; 9-10 etc..
Example is attached. Any tip where to start is appreciated
Thank you in advance.
Capture.JPG
Last edited by kueva14; 03-22-2020 at 05:38 AM.
If your intervals are as outlined, i.e. hourly, you might consider pushing the data into a Pivot Table then adding Process End as Row Field, right click and Group (Hours (only)), then add Orders to the Data field and set to Average.
If you need more assistance, post a sample file to illustrate - and remember to include desired output based on sample data.
More assistance would help
I have attached a sample file.
refer attached -- you can remove the SUM / COUNT fields, these are just to illustrate what you could choose to show.
Thanks for the help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks