4 Replies Latest reply on Sep 5, 2018 2:19 AM by pietro.tamburini

# Compare single individual values with group average

Hello all,

I am new in Tableau. Here's my idea: I have a set of 100 individuals, divided into 4 groups (1, 2, 3 and 4), and a set of variables defined at an individual level. I would like to select an individual from the a down menu and visualise individual values, the group average for the same value and the overall average value, so to compare them quickly. I am trying hard but I can't find a way to link single individual values with group averages.

• ###### 1. Re: Compare single individual values with group average

Hi Pietro,

I am using the data from another Thread. So Similar to What you need, This is the View and You need to Use a Lookup Filter to Filter City, Which is different from Normal Filter to Filter Results per City. The view Shows Average per city, Per State and Overall average.

When Filtering for Hartley, you get

Thnaks

Deepak

• ###### 2. Re: Compare single individual values with group average

Thank you very much Deepak.

Actually, my problem does not lie on the filtering side of the process, but rather on letting the average per group show up alongside the single value.

I see on your sheet that you already have an "Average per state" field already computed, upon which you apply the "sum". I was trying to apply the "avg" calculation on the value, basing on "group number" as guiding variable. How did you manage to obtain the "average per state" as an already computed variable? also, please note that I would like to obtain bar charts out of the data.

thanks

Pietro

• ###### 3. Re: Compare single individual values with group average

You can Do anything with the data , create bar chart or Cross tabs. If you check average per State , I used The formula which would result into Average Per State. If you Check Average per City, I have both State and City in Formula to give you Average for a City with in that State. I used LODs. You can Read about them here:

Hope It Helps

Thanks

Deepak

1 of 1 people found this helpful
• ###### 4. Re: Compare single individual values with group average

Thank you very much for your support. I finally made it using LOD expressions. I added in the measures the average per group detail coding:

{ FIXED (GROUP) : AVG(VALUE)}

and adding it in the visualization tab alongside the individual values.

thank you!