1 Reply Latest reply on Sep 5, 2018 7:16 AM by Arun Kumar

    Average if from different sheets

    Arun  Kumar

      Hi,

      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.

       

       

      Thanks.