I have 8 different sheets. Out of which 7 has metrics by each month calculated by different Site and Service. Also i have a sheet which shows who is covering for the same time frame. Below provided is the example with 3 sheets:
Sheet 1 - Coverage by each month by Site and Service
Sheet 2 - Calculated average metrics by site and service
Sheet 3 - Calculated average metrics by site and service
Sheet 4 - This is what i wanted (by Person -average for each metric)
On Excel i did the averageif. Can anyone help me with how this can be done in tableau? What is the easiest to do this, because i have several metrics from different sources.
Sheet 4 is on the right to sheet 1,2 & 3