Product Tour
forums
Use these forums to ask questions and discuss Tableau.
Create calculated reference lines
Posted April 23rd, 2008 by KJHill
in Calculations
I am trying to calculate an average for a whole group as opposed to an individual average. So the graph would show the individual average and the reference line would be the group average.
Comments
You can aggregate a measure by "Average" while also adding an "Average" reference line. This should work whether you have single groups or multiple groups. See the attached example.
Note that the aggregated averages displayed for "Egrets Landing" and "Whiskey Point" in the Single Group sheet match the reference line averages in the Multiple Groups sheet.