Median with Tableau ​

Context ​

As for now, Indexima does not support the MEDIAN function.

However, there is a way to display a MEDIAN within Tableau using Indexima.

How to ​

Use the WINDOW_MEDIAN function and define the computation to the most detailed level.

How to in detail ​

Example context ​

Let's consider a Sales process by a salesman and we want to display the Median of the duration.

Sales duration is defined as the difference in days between the start date & the end date.

The most detailed level is the Sales Id.

Step1: Create the measure using the WINDOW_MEDIAN ​

The measure would be defined as WINDOW_MEDIAN(max([Sales Duration])).

Step2: Use the measure and define the proper table computation level ​

Whatever the axis, apply the following steps:

  1. Add the measure as TEXT
  2. Add the most detailed level as DETAIL (in this example, SalesId)
  3. In table computation of the Median, choose "Specific Dimensions" then tick the box with the most detailed level (in this example, SalesId)
  4. Write MIN(1)  (as a measure) in the columns. After validating the creation, this will be transformed as a tile.
  5. Change the marks into TEXT
  6. (optional) Hide the header: Right-click on the axis, then untick the "Show header" option

Median (of SalesId) without any axis declination ​

Median (of SalesId) per Sales Person ​