KNOWLEDGE BASE

Median Function Unavailable


Published: 16 Sep 2013
Last Modified Date: 28 Feb 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

Resolution

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

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?