CODEWITHSUNDEEP
mysqltableau-api
Mateusz P
Mateusz P

Reputation: 221

Tableau creating calculating column for whole table

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.

Upvotes: 1

Views: 117

Answers (1)

Fabio Fantoni
Fabio Fantoni

Reputation: 3167

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.

Upvotes: 1

Related Questions