Last Modified Date: 06 Jan 2020
- Tableau Desktop
- Live connection to some data sources
- Amazon Athena
- Amazon Redshift
- Cloudera Hadoop
- HP Vertica
- IBM DB2 zSeries
- SQL Server
- IBM Netezza (aka IBM PDA)
- Legacy Connections to Excel or Text Files
- SAP HANA
ResolutionAs 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.
CauseWhen connecting live to a database, then Tableau Desktop queries the database for any functions requested. This allows Tableau Desktop to take advantage of the performance of the database.
Not all databases have a built-in median function, thus Tableau Desktop is not able to send a query with median to these databases.
Additional InformationTo voice your support for the inclusion of this feature request in a future product release, add your vote to the following Community Idea: Percentile function on LIVE connection.
You may also consider contacting support for the database in use to enter a feature request for the database itself to include the median function.
Discuss this article...
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials