2 Replies Latest reply on Apr 4, 2013 8:32 AM by Saken Kulkarni

    calculated field to segment values greater than median

    Saken Kulkarni

      Hi all,

       

      I am trying to create a segmentation in Tableau. I want to return all values greater than the median value for that particular segment and segment them

       

      So, let us pretend that the median Opportunity ($) is 100

       

      I am writing a statement that says

      if [Opportunity]>100 then "Segment 1" else ...(more if statements)

       

      How do I replace 100 with the MEDIAN value of opportunity for that segment? I tried

       

      if [Opportunity]>MEDIAN([Opportunity] but that doesn't seem to work.

       

      THoughts?