5 Replies Latest reply on Feb 8, 2017 11:12 AM by Shinichiro Murakami

How do I create a calculated field which is the average of selected rows of data?

Vicci Barrett Feb 3, 2017 6:48 AM

I have created a box plot of University league table scores over time and have picked out one university to show on a trend line across the chart. I would like to add another reference line that shows the average of a sub-set of universities (for example, Bolton, Cumbria and Manchester Metropolitan) across the chart, but for the life of me cannot work out how to do it. I'm guessing I need to add another calculated field but I can't seem to combine the IF statement with an aggregation. What formula to I need in the calculated field?

Many thanks in advance

Vicci

ExampleWorkbook.twbx 28.2 KB

1. Re: How do I create a calculated field which is the average of selected rows of data?

Shinichiro Murakami Feb 3, 2017 2:05 PM (in response to Vicci Barrett)
Hi Vicci,

You can create "Set" from University Filed.

Then create calculated field.

// Float is to make the field type to dicimal number to make the axis synclonized
[Selected Score]
FLOAT(if [Selected Univ.]then [Overall Score] end)

You can change the University in the list with editing the Set of "Selected Univ.".

Thanks,
Shin

ExampleWorkbook_SM_9.3.twbx 37.4 KB
Like Show 0 Likes(0)

Actions
2. Re: How do I create a calculated field which is the average of selected rows of data?

Vicci Barrett Feb 6, 2017 2:35 AM (in response to Shinichiro Murakami)

Hi Shin
Unfortunately when I try your suggestion, my set of universities display as separate lines on the chart, rather than one line showing the average of the set (I tried changing the Measure from Sum to Avg, but this hasn't worked). I have looked at the example workbook you sent back, but I can't work out out how made the Selected Univ. set show only as one line? Am I missing a step? Many thanks for all your help!
Vicci
Like Show 0 Likes(0)

Actions
3. Re: How do I create a calculated field which is the average of selected rows of data?

Shinichiro Murakami Feb 6, 2017 6:55 AM (in response to Vicci Barrett)

Not exactly sure what you are seeing , but could you try this one?
Please attach screen shot or packagd workbook with failure if you still have trouble.

Thanks,
Shin
Like Show 0 Likes(0)

Actions
4. Re: How do I create a calculated field which is the average of selected rows of data?

Vicci Barrett Feb 8, 2017 1:30 AM (in response to Shinichiro Murakami)

Thanks for all your help, Shin. It was because the University pill was in the Measure Values card. Once I took that out, it was fine.
V
Like Show 0 Likes(0)

Actions
5. Re: How do I create a calculated field which is the average of selected rows of data?

Shinichiro Murakami Feb 8, 2017 11:12 AM (in response to Vicci Barrett)

Sounds good.

Shin
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community Forums

How do I create a calculated field which is the average of selected rows of data?

1. Re: How do I create a calculated field which is the average of selected rows of data?

2. Re: How do I create a calculated field which is the average of selected rows of data?

3. Re: How do I create a calculated field which is the average of selected rows of data?

4. Re: How do I create a calculated field which is the average of selected rows of data?

5. Re: How do I create a calculated field which is the average of selected rows of data?

Sign In or
Create your Account

Actions

More Like This

Sign In or Create your Account

Sign In or
Create your Account