1 Reply Latest reply on May 19, 2015 7:57 AM by pooja.gandhi

    How to Convert "average if" in Tableau

    Prima Baines

      I need to convert this formula from excel in tableau

       

      =AVERAGEIFS([Minutes],[Name],[@[Name]])

       

      I am basically trying to do an average of the values in the minutes column, but only if the names in the column name matches.

       

      Thank you.

        • 1. Re: How to Convert "average if" in Tableau
          pooja.gandhi

          Prima - I do not understand what you mean when you say, if the names in the column name matches? matches to what? Can you give us some sample data to look at?

           

          There might be a couple of ways to do this based on how the data is structured. You could do something like

           

          IF ATTR([NAME] )= "Your choice" THEN average([Minutes]) END

           

          OR you can use show/hide filter to only show names that suffice the condition and use the inbuilt average calculation.

           

          I can not help much without seeing the actual data.

          1 of 1 people found this helpful