KNOWLEDGE BASE

MEDIAN() Calculation Sometimes Returns 'nan' Instead of Expected Value


Published: 08 May 2017
Last Modified Date: 09 May 2017

Issue

When making changes to a view, such as changing a filter, then sometimes a calculated field using the function MEDIAN() returns unexpected 'nan' results.

Environment

Tableau Desktop

Resolution

Remove and recreate the extract: 
  1. In Tableau Desktop, navigate to Data > {data source name} > Extract > Remove
  2. Select either option and click OK
  3. Navigate to Data > {data source name} > Extract Data…
  4. Select any desired extract options and click Extract.
Did this article resolve the issue?