Hi,

I am retrieving response times from a SQL Datasource. There are currently in the format "hh:mm:ss", but I can change them in SQL if need be. My problem is I want to be able to drop these times into the dataarea of a PivotGrid and have it display the Average time. I've searched everwhere and tried pulling in different formats as well as trying to format the values differently, but I cannot seem to get what I want.

 

Any ideas?  Thank you

James Brooks

What is the type of your "hh:mm:ss" ?
You may need a TimeSpan instead of a DateTime, because getting the average of a date does not work, because it is not possible to add DateTimes. You could do that with TimeSpans (TimeSpans = durations).

 Thanks Marc. that worked great. I imported the times as a timespan, averaged then, then used a custom formatter to get the right time format displayed.

I appreciate your help.

 

James Brooks

Glad to know you could make it !