Last Modified Date: 30 Nov 2023
Environment
- Tableau Desktop
- Live connection to some data sources
- Access
- Amazon Athena
- 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
When 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 Information
To 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.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials