Ultimate Tableau Desktop Course - Beginner to Advanced Bundle - Numeric Expressions and Automatic Calculations

This video tutorial covers the use of calculated fields in Tableau, focusing on numeric functions such as ABS, Sign, and ZN. It explains how these functions can be used to manipulate data without altering the original dataset. The tutorial also delves into rounding functions like Ceiling, Floor, and Round, and demonstrates their application in data analysis. Finally, it discusses the use of Min and Max functions to identify the smallest and largest values in a dataset.

What is the primary purpose of calculated fields in Tableau?

• To create visualizations automatically

• To permanently alter the original dataset

• To delete unnecessary data

• To enhance data analysis without changing the original dataset

Which function in Tableau returns the absolute value of a number?

• FLOOR

• SIGN

• ZN

• ABS

What does the SIGN function return when the input number is negative?

• 1

• 0

• The same negative number

• -1

What value does the ZN function return if the input is null?

• 0

• The previous value

• 1

• Null

How does the Ceiling function round a number?

• To the nearest odd number

• To the nearest even number

• To the nearest integer of equal or greater value

• To the nearest integer of equal or lesser value

Which function rounds a number down to the nearest integer?

• ABS

• ROUND

• FLOOR

• CEILING

What is the syntax for the ROUND function in Tableau?

• ROUND(decimal)

• ROUND(number, decimal)

• ROUND(decimal, number)

• ROUND(number)

If you want to round a number to the nearest thousand, what should the decimal argument be set to?

• 3

• -3

• 4

• -4

Which function returns the smallest value from a list in Tableau?

• AVG

• MIN

• SUM

• MAX

What does the MAX function do in Tableau?

• Returns the largest value from a list

• Returns the sum of values from a list

• Returns the average value from a list

• Returns the smallest value from a list