1 Reply Latest reply on Jan 18, 2018 6:03 AM by Sasha Hanna

    Calculated accurate construct / domain averages in Tableau

    Samara Cooper

      Hi everyone

       

      I am tying to calculate accurate construct / domain averages in Tableau. I would like to be able to calculate the average for the construct per person first (Approach I below - although keep in mind that my real data is pivoted so that it works better with Tableau).

       

      I can get as far as this table (Note: Collaboration has 5 questions in it. The second column is an average of these questions calculated in Tableau). But I can't get the total construct average of collaboration for all 17 people (namely the average of the second column calculated in Tableau).

       

       

      Can anyone help??