1 2 Previous Next 19 Replies Latest reply on Nov 3, 2017 11:13 AM by Yingying Zeng

    Error using median function

    Jason Wilson

      I am unable to use the Tableau Window_Median function on an integer field and I do not understand why.  Here is my formula:

           WINDOW_MEDIAN( [duration])

       

      The duration field is straight from the db and is an INT with no NULLS.  The error I am getting is: 

           "All fields must be aggregate or constant when using table calculation functions or fields from multiple data sources."

        1 2 Previous Next