6 Replies Latest reply on Mar 15, 2017 11:01 PM by Karthik Venkatraman

    exclude current row data from window average

    Karthik Venkatraman

      Hi All,

       

      I have a student average marks information and i am working on performing some statistical things to find out the significance of the student vs overall score. Below is the screenshot of my data and I have also attached the data for reference.

       

      I am able to get the overall window average using the tableau's WINDOW_AVG function however i want to exclude the current row from being considered in the average.

       

      Untitled.png

       

      For example, when i am calculating the overall average of student 7210, i must leave the 7210 student's Avg (83.320754717) and use the remaining student average for the overall average calculation. Similarly when calculating for 7211, i must leave the student avg (77.75806452) from being calculated.

       

      Can anyone let me know how to proceed with this calculation.