Median Function Unavailable

Published: 16 Sep 2013
Last Modified Date: 12 Apr 2017


When you try to create a calculated field, the MEDIAN function is not available.


  • Tableau Desktop
  • Access
  • Amazon Redshift
  • Cloudera Hadoop
  • HP Vertica
  • IBM DB2 zSeries
  • MySQL
  • SQL Server
  • Teradata
  • IBM Netezza (aka IBM PDA)
  • Legacy Connections to Excel or Text Files


As a workaround, create an extract. For more information, see Extracting Data.

Depending on your scenario, using a Window Median Table Calculation might also resolve the issue. However please note that this table calculation only returns the median of the expression within the window. For more information about this topic, see WINDOW_MEDIAN in the Online Help


The MEDIAN function is not available for live connections to the data sources listed in the Environment section.


Did this article resolve the issue?