Tableau creating calculating column for whole table

user_13687308 0
Viewed 52

Is tableau has a opportunity to create calculated column for table? For example here are 2 column with some number and I want to make third column with formula like this If(column1>column2;column1;column2. I see there is option to create calculated field with summarize columns but I just want to compare them.

tableau-api mysql
1 Answers

If you only want to create a new column storing the max between 2 original column, you just need to create a calcultaed field like the following:

if column1 > column2
then column1
else column2
end

EDIT Or even simpler

MAX([column1], [column2])

There are two (overloaded) functions named MAX(). With one argument, MAX() is an aggregate function that operates on a column of values and returns the maximum - just like other aggregate functions like SUM(), AVG() etc. With two arguments, MAX() is a record level function that operates on an individual data row and returns the larger of its two arguments. MIN() behaves similarly.

user_46893910
Related