1 Reply Latest reply on Dec 11, 2013 2:08 AM by Manas Ranjan Kar

    Calculate Median with other conditions

    Jakub Drhlik

      hi all,

       

      i have data (see the spreadsheet) which comes from a DB. I have severals columns but basically I need to create a calculated field with  a median value for the 4th column (catalogue_open) but those values differ by domain type and date as well. So I need to find a median value for the first day and platform A, then median value for platform B and for platform C.

      Then same for the second day and then all NEEDS to be summed up.

       

      so the end result would be basically summing up only 235+40+128+76+567+23...

       

      I know how to write it in sql but cant work it out in tableau. any help please?

       

      Thank you in advance for any tips.

       

      Jakub