1 Reply Latest reply on Sep 17, 2013 9:20 PM by Alex Kerin

    calculating the difference between an aggregate median and a row level value

    jeremy.schneider

      I have a table of 100 dates with sales count for each date.  I'd like to calculate the median sales for that entire dataset (or whatever filter I have applied at the moment) and then see how each row compares to that median calculation.

       

      Essentially, I'd like my formula to be:

       

      (Sales on a specific day / Median of all sales)*100 to create an index but Tableau doesn't let you mix aggregate and non-aggregate functions.

       

      Thoughts?