I have a large table of data (30k rows), where I am trying to display sums and averages per day of the week by each hour in the day. I can get the table to display the sums, but I can't figure out how to make it show the average over that time period.
These are medication dispenses from a hospital pharmacy. The orders are placed at a specific date/time (Orig order dt/tm), dispensed from the pharmacy at another time (Disp dt/tm) and scheduled to start at another time (Start dt/tm). I am evaluating each of these date/time parameters, but looking at hard numbers is of limited value. I need to see the averages by each day of the week in one hour increments. I should be able to figure out how to make the other dates work once I get this first one based on Start date/time figured out.
You can see in my first image, I don't have any trouble getting the pivot table to show me the total dose sums per time slot, but I can't figure out how to get it to display a useful average.
Source Data table example:
Example of data for Sundays from midnight until 1am.
Thanks in advance for any help.
These are medication dispenses from a hospital pharmacy. The orders are placed at a specific date/time (Orig order dt/tm), dispensed from the pharmacy at another time (Disp dt/tm) and scheduled to start at another time (Start dt/tm). I am evaluating each of these date/time parameters, but looking at hard numbers is of limited value. I need to see the averages by each day of the week in one hour increments. I should be able to figure out how to make the other dates work once I get this first one based on Start date/time figured out.
You can see in my first image, I don't have any trouble getting the pivot table to show me the total dose sums per time slot, but I can't figure out how to get it to display a useful average.
Source Data table example:
Example of data for Sundays from midnight until 1am.
Thanks in advance for any help.
