InterSystems MDX Reference
MEDIAN


MEDIAN(set_expression, optional_numeric_expression)
SELECT {MEASURES.[%COUNT],MEASURES.[encounter count],MEASURES.[avg test score]} ON 0, birthd.decade.MEMBERS ON 1 FROM patients Patient Count Encounter Count Avg Test Score 1 1910s 80 5,359 75.17 2 1920s 227 12,910 74.20 3 1930s 567 33,211 74.67 4 1940s 724 38,420 73.39 5 1950s 1,079 46,883 73.72 6 1960s 1,475 57,814 74.16 7 1970s 1,549 49,794 74.35 8 1980s 1,333 35,919 74.13 9 1990s 1,426 29,219 74.79 10 2000s 1,406 20,072 74.95 11 2010s 134 1,346 73.55
SELECT {MEASURES.[%COUNT],MEASURES.[encounter count],MEASURES.[avg test score]} ON 0, MEDIAN(birthd.decade.MEMBERS) ON 1 FROM patients Patient Count Encounter Count Avg Test Score MEDIAN 1,079 33,211 74.20
SELECT MEDIAN(birthd.decade.MEMBERS, MEASURES.[%COUNT]) ON 0 FROM patients MEDIAN 1,079