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

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

Actions

More Like This