Loading

Tableau Median Function Unavailable When Creating a Calculated Field with a Live Database Connection

Publiseringsdato: May 12, 2025
Beskrivelse

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

 

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.

 

Løsning

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. 

 

Flere ressurser

To voice your support for the inclusion of this feature request in a future product release, add your vote to the following Salesforce 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.
 

Knowledge-artikkelnummer

001473761

 
Laster
Salesforce Help | Article