KNOWLEDGE BASE

Median Function Unavailable


Published: 16 Sep 2013
Last Modified Date: 10 Nov 2017

Issue

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

Environment

  • 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
  • SAP HANA

Resolution

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

Cause

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

 

Did this article resolve the issue?