1 Reply Latest reply on Dec 21, 2017 8:41 AM by Shinichiro Murakami

How to add a column with own calculations to an existing table? Tableau 10.4.1

Ivan Johansson Dec 21, 2017 8:02 AM

I have a table with values divided by positions (Pos1 to Pos4) and I want to add an own calculation over rows to be able to prioritize which row that has the biggest variation compared to average.

I have a solution, in sheet "Col calc 2", but I believe this can be done much simpler and more generic, ie. I see big problem if I have 20 positions with this solution

I would also like to use built in functions if possible to calculate STDEV on a row and AVERAGE if possible to simplify the calculations.

Tableau Column calc problem.twbx 194.6 KB

1. Re: How to add a column with own calculations to an existing table? Tableau 10.4.1

Shinichiro Murakami Dec 21, 2017 8:41 AM (in response to Ivan Johansson)
Hi Ivan

To achieve this in one worksheet, you need to prepare two data sets.

Edit data source => duplicate data source with Union.

You can merge below four into one..

== Be carefull ==
Because we duplicated data, you might need to take care the calculation to remove the duplicated value in somewhere.

Regards,
Shin

Tableau Column calc problem_SM_10.4.twbx 195.0 KB
Like Show 0 Likes(0)

Actions

Tableau Community Forums

How to add a column with own calculations to an existing table? Tableau 10.4.1

1. Re: How to add a column with own calculations to an existing table? Tableau 10.4.1

Sign In or
Create your Account

Actions

More Like This

Sign In or Create your Account

Sign In or
Create your Account