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.