MEDIAN is calculated correctly when using Google Sheets data source, but does not when using the "Extract Data" data source.
I have setup the following Google Sheet with a series of test data, Metric A and Metric B have 4 values. Metric C has 5 values.
I have setup a Google Sheets Data Source to this sheet, and then setup a Extract Data Data Source (which is linked to the Google Sheets Data Source).
Finally, I setup a test Dashboard. The top table is using the Google Sheets data source, while the bottom table is using the Extract Data data source.
In the top table (Google Sheets), the MEDIAN value is calculated correctly for for an even number of series number, by finding the MEAN value of the 2 middle values.
In the bottom table (Extract Data), the MEDIAN value is calculated incorrectly. Instead of the MEAN of the 2 middle values, the greater of the 2 middle values is returned. This is shown in Metric A and Metric B. Details
I'm not sure of a way to get this to work with the Extract Data connection. Seems to me a bug with the Extract Data connector and/or Data Studio.
Note: I have cross-posted this in the Google Community forum here.