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).
Try the following table calculation: window average (calculation above [second table with 17 rows]). It is a bit difficult to guide you without seeing the different steps you took to get there. If that doesn't help you, could you please recreate your problem with Sample superstore or dummy data and attach the workbook?