I have created a pivot table and when I try to add a time field to Rows the Pivot Table groups the same times together. I need all times to show individually. I cannot calculate an average time without all of the times. each time is associated with an Incident Number. When I show a count of incident numbers you can see which ones are grouped. I have already gone into options/data and checked Disable automatic grouping of Date/Time columns in Pivot Tables.
You need a weighted average, rather than a regular average. So, multiply each response time by its frequency and divide the sum by the total number of incidents. Or, create a pivot table with the incident number in the Rows area and the response times in the Value area. Then average the response times. Though, for the latter to work you need to filter out the incidents that have no response time as these lead to negative times indicated by all the ######### in your data. Best to clean the data first and investigate/eliminate the ####### values.
See attached.
Thank you so much, that is very helpful.