franswa3434
Board Regular
- Joined
- Sep 16, 2014
- Messages
- 69
Hey everyone,
I need to find a way to break a report that shows the number of orders for a customer and the number of days it took to process the orders, then find a way to get the mean for each individual order. For example. if a customer has 3 orders and it took 3 days, and it to find the median of 3, 3, and 3.
To further clarify, if we had 2 customers, in which the first had 3 locations that took 3 days to process, and the second had 1 order which took 10 days, I would need to find the median of 3, 3, 3, and 10.
Below is an example of 3 customers.
This is what I am provided.
<TBODY>
</TBODY>
I need to somehow come up with a way, where instead of getting a median of 3, 10, 6 (median of 6), it would actually find it as if it were listed as 3, 3, 3, 10, 6, 6 (median of 4.5).
I also need to be able to add to the list customers, orders, and their intervals to this list as my customer base grows.
Also, I can add additional sheets to this list, as well as columns. Just not rows.
Please let me know if further clarificaiton is needed, as I don't think I explained it very well.
Thanks everyone!
I need to find a way to break a report that shows the number of orders for a customer and the number of days it took to process the orders, then find a way to get the mean for each individual order. For example. if a customer has 3 orders and it took 3 days, and it to find the median of 3, 3, and 3.
To further clarify, if we had 2 customers, in which the first had 3 locations that took 3 days to process, and the second had 1 order which took 10 days, I would need to find the median of 3, 3, 3, and 10.
Below is an example of 3 customers.
This is what I am provided.
Customer</SPAN> | # of Orders</SPAN> | Days to Process</SPAN> |
ABC123</SPAN> | 3</SPAN> | 3</SPAN> |
XYZ321</SPAN> | 1</SPAN> | 10</SPAN> |
Qwerty</SPAN> | 2</SPAN> | 6</SPAN> |
<TBODY>
</TBODY>
I need to somehow come up with a way, where instead of getting a median of 3, 10, 6 (median of 6), it would actually find it as if it were listed as 3, 3, 3, 10, 6, 6 (median of 4.5).
I also need to be able to add to the list customers, orders, and their intervals to this list as my customer base grows.
Also, I can add additional sheets to this list, as well as columns. Just not rows.
Please let me know if further clarificaiton is needed, as I don't think I explained it very well.
Thanks everyone!
Last edited: