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

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

Assessment

Interactive Video

•

Information Technology (IT), Architecture, Social Studies

•

University

•

Practice Problem

•

Hard

Created by

Wayground Content

FREE Resource

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.

Read more

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

FLOOR

SIGN

ZN

ABS

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

1

0

The same negative number

-1

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

0

The previous value

1

Null

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which function rounds a number down to the nearest integer?

ABS

ROUND

FLOOR

CEILING

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the syntax for the ROUND function in Tableau?

ROUND(decimal)

ROUND(number, decimal)

ROUND(decimal, number)

ROUND(number)

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?