Tableau: Average by Dimension

Question

I would like to average N by Type for values of Inst

My data is set up as:

Type, Inst, N
A, A1, 4
A, A1, 13
A, A1, 13
A, A2, 4
A, A3, 5
B, B1, 4
B, b2, 10

So I would like to see a table (or bar chart) with A: 13, B:7. Any suggestions? If I put AVG(N) in rows and Type in columns I get A: 7.8, B:7

The problem is that Tableau is averaging all N per Type, but I want the numerator to be the total N for the Type while the denominator is the number of unique Inst within that Type

score 6 · Accepted Answer · answered Feb 12 '16 at 22:20

6

Create a calculated field desired_avg as

{FIXED [Inst] : SUM([N])}

put it in the sheet .

select aggregation as AVG and not SUM

Let me know if that worked !

answered Feb 12 '16 at 22:20

minatverma

1,090
13
24

yes, thank you! I was looking for a solution that used LoD expressions – As3adTintin Feb 16 '16 at 14:55
any suggestion on how to get cell reference lines / box plots for each type? – As3adTintin Feb 16 '16 at 15:22
You need to share your workbook / sample data to get me going on this ! – minatverma Feb 16 '16 at 15:38

score 2 · Answer 2 · answered Feb 13 '16 at 06:48

2

Define the following calculated field

Sum(N) / countd(Inst)

answered Feb 13 '16 at 06:48

Alex Blakemore

11,301
2
26
49

thanks, suggestions if i wanted a median instead of avg? – As3adTintin Feb 16 '16 at 15:18
Could just be Median(N) -- if you don't care about multiple instances of the same type being treated as distinct values. Otherwise, you'll have to think about what exactly you want the Median to represent and define the calculation accordingly. – Alex Blakemore Feb 16 '16 at 17:48

Tableau: Average by Dimension

2 Answers2