calculate median

[cvuas]

I am a pure beginner in csharp.

In my report, I have to group the results of an sql query data and calculate the average min., max. and median (I have three grouping categories: category I, II and III). For the average, min and max I can use the AVE-, MIN- and MAX-functions.
To calculate the median, I found the following c#-script:

public static double Median(this IEnumerable<double> list)
        {

            List<double> orderedList = list
                .OrderBy(numbers => numbers)
                .ToList();

            int listSize = orderedList.Count;
            double result;

            if (listSize % 2 == 0) // even
            {
                int midIndex = listSize / 2;
                result = ((orderedList.ElementAt(midIndex - 1) +
                           orderedList.ElementAt(midIndex)) / 2);
            }
            else // odd
            {
                double element = (double)listSize / 2;
                element = Math.Round(element, MidpointRounding.AwayFromZero);

                result = orderedList.ElementAt((int)(element - 1));
            }

            return result;
        }  


As I am an absolute c#-beginner, I don't know how to pass the sql-result of each group to the median-function... :-( I would be very thankful, if someone could provide me any hint.

[Hinata]

Hello cvuas,

I believe there is no built-in aggregate function in the reporting that will give you the median. In such cases you can implement your own function, but I am afraid it will require some C# knowledge. For more information on how this is done follow these help articles:
http://www.telerik.com/help/reporting/expressions-user-functions.html
http://www.telerik.com/help/reporting/expressions-user-aggregate-functions.html

[IvanY]

Hello Hubert,

In your case you will have to implement a user aggregate function. To do so please check this help article. Once you have implemented your user function you will be able to use it like the rest of the predefined functions in an expression - for more information please check the Expressions help article and the related subarticles.

However please note that since you are a beginner in C# most probably it will be best to catch up a little bit prior to implementing the function. Depending on your current knowledge and previous experience with programming you might want to check the C# Programming Guide, the C# Reference and the C# Tutorials.

Regards,
IvanY
Telerik