May 6, 2013 at 3:48 am
I am querying a database that holds the length of time an event took and what I am trying to achieve is to be able to record the average, maximum and the median of these times in a matrix table grouped by the month the event took place.
The average and maximum are fine as they are built in functions but as I am using 2008 there isn't a built in function for the median. I have found some custom code that correctly reports the median but it only reports the median for the whole period not the individual grouped months.
Could any provide me with some code or point me in the direction of some useful guides as I have struggled to find what I am after but it may be the words I am using in my searches.
Many thanks.
May 6, 2013 at 9:56 am
Something to try. I've never found median to be a very meaningful number. Anyhoo. :hehe:
http://techfilth.blogspot.com/2008/07/calculate-median-on-group-in-ssrs.html
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply