Calculations in Tableau

What this calculation will return if the order date is 6/13/2021 and the ship date is 9/19/2022?

DATEDIFF('year',[Order Date],[Ship Date])

• 3

• 6

• 0

• 1

What is the output of the following function? SPLIT('Tableau Developer', ' ', 2)

• Tableau

• Developer

• a

• ab

Which of the following fields will not be aggregated when you add it into the view?

• Calculated Field SUM(Sales)

• A continuous measure [Profit]

• Calculated Field [Profit]*10

• All of the above

Groups can be used in a calculated field.

• TRUE

• FALSE

What is the selected mark type to create the highlight table?

• Circle

• Square

• Text

• Shape

Which of the following are valid calculations? (Select all that apply)

• MAX(SUM(Profit), (Sales))

• SUM([Profit]) * SUM([Quantity])

• SUM([Profit]) * 1000

• SUM([Profit]) * [Quantity]

When creating a calculated field in Tableau, which function is used to calculate the cumulative sum of profits across all months?

• WINDOW_SUM(SUM(Profit))

• RUNNING_SUM(SUM(Profit))

• TOTAL(SUM(Profit))

• SUM(Profit) / TOTAL(SUM(Profit))

When creating a calculated field in Tableau, what function is used to round a numerical value to the nearest whole number?

• ROUND(Sales)

• INT(Sales)

• CEILING(Sales)

• ROUND(Sales, 0)

When creating a calculated field in Tableau, what function is used to calculate the difference between two numerical values?

• DIFFERENCE(Sales1, Sales2)

• ABS(Sales1 - Sales2)

• Sales1 - Sales2

• DELTA(Sales1, Sales2)

In Tableau, what is the correct calculation to find the average sales per product for each product sub-category?

• AVG(SUM(Sales)) / COUNTD(Product)

• SUM(Sales) / COUNTD([Product category])

• AVG(SUM(Sales)) / COUNTD(Product Sub-Category)

• SUM(Sales) / COUNTD([Product Sub-Category])