2 Replies Latest reply on Feb 28, 2018 6:37 AM by Vikram Gokhale

    Table Calcs : Ignore certain values in Window_Avg function

    Vikram Gokhale

      Hello friends, I am fairly new in the exciting world of Tableau. So needed some guidance.

      Sorry, was in a rush and didn't get a chance to cleanup confidential data, so am not attaching TWBX at the moment. Can do so if need be.

      But in the attached image, I need to get average of each of the columns. Tried using WINDOW_AVG but the blank cells get

      accounted and give incorrect value. What would be the best possible way to achieve this ?

      Thanks,