Ok everyone, I have spent some time trying to work this out but I feel that I need to ask for assistance. I have a simple data table, that has a daily time value added for each day. Table includes three critical fields. Date and Time (how long it took for a process to complete).

I created a pivot table , but since you are not able to calculate a median from within the pivot table, I created an array calculated field that displays the calculated median. So in this Pivot table I now have the date, minTime, maxTime, and the foreign Median. I try to create a line graph to plot all three values per month, but only the minTime and maxTime display on graph.

Please assist. I have attached a sample

Attached Files

Pivot with Mean.xlsx (21.4 KB, 7 views)

Maybe like shown in Pivot_2

Attached Files

Pivot with Mean_2.xlsx (38.8 KB, 9 views)

I see that you used the Average function within the table. In some cases the average and median might be similar, but with the tight ship our health organization is running, they want to look at the actual median of the set of numbers, in this case the median for all times entered during each month. Let me know if I may not be looking at your sheet correctly.

Thank you

I have added column E in sheet Data and here calculated the median using a formula similar to your own.

Note that the median in Pivot_2 is exactly 32 while =AVERAGE(Data!C2:C100) is 32,8484848484849.

Please note that the data source of Pivot_2 is Data!A1:E100.