6 Replies Latest reply on Jan 29, 2014 10:05 AM by Patti Scriffiny

    Can someone help with medians?

    Patti Scriffiny

      I am trying to display a set of data in terms of its median, as opposed to a sum or an average.  I have found an article in the knowledge base that says since my data came from Excel, the median feature is not available.  There was some SQL language there but I couldn't edit it to make it work in my workbook.  I don't know enough about SQL to know how to edit the sample code.  Can anyone help?  All I want to do is take a field (in this case a percentile score) and display the median percentile for various groups.