0 votes
1 view
in BI by (17.6k points)

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 Nfor the Type while the denominator is the number of unique Inst within that Type


1 Answer

0 votes
by (47.2k points)
selected by
Best answer
  • You can create a calculated field desired_avg as

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

  • Now, put it in the sheet.

  • Select aggregation as AVG and not SUM
Welcome to Intellipaat Community. Get your technical queries answered by top developers !