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?