FREE Tableau Calculations and Parameters Questions and Answers

Question 1

An analyst needs to create a calculation that shows the average sales for each customer, regardless of what other dimensions (like Region or Product Category) are shown in the visualization.
The value should remain fixed for each customer.
Which type of calculation should be used to achieve this?

Accepted Answer

A FIXED Level of Detail (LOD) expression

Answer

A Table Calculation

Answer

A basic aggregation like AVG([Sales])

Answer

An INCLUDE Level of Detail (LOD) expression

Question 2

A dashboard creator wants to allow users to dynamically change the date part for a DATEDIFF calculation (e.g., switch between seeing the difference in days, months, or years) without editing the worksheet. Which Tableau feature is best suited for this requirement?

Accepted Answer

A parameter

Answer

A calculated field with a CASE statement

Answer

A quick filter

Answer

A set

Question 3

You are analyzing sales performance and want to calculate the difference in sales between the current month and the previous month for each product. Which of the following is the most appropriate type of calculation to use?

Accepted Answer

Table Calculation

Answer

Level of Detail (LOD) Expression

Answer

Basic Expression

Answer

Parameter Control

Question 4

An analyst is creating a calculated field to determine the number of days between a customer's `[Order Date]` and the `[Ship Date]`. The correct syntax for this calculation is `DATEDIFF('day', [Order Date], [Ship Date])`. What will be the result if a specific order's `[Ship Date]` is earlier than its `[Order Date]`?

Accepted Answer

A negative integer

Answer

A positive integer

Answer

A NULL value

Answer

A #ERROR message

Question 5

Which of the following describes a key difference between a Tableau Parameter and a Filter?

Accepted Answer

Parameters can be used across multiple, different data sources, while a standard filter is tied to a single data source.

Answer

Filters are always single-select, while Parameters can be multi-select.

Answer

Parameters directly remove data from the view, while Filters require a calculated field to affect the data.

Answer

Filters can accept any data type, while Parameters are limited to strings.

Question 6

A view shows SUM(Sales) by Region and State. The analyst wants to create a calculation that computes the total sales for each Region, effectively ignoring the State dimension that is present in the view. Which LOD expression would accomplish this?

Accepted Answer

EXCLUDE [State] : SUM([Sales])

Answer

INCLUDE [Region] : SUM([Sales])

Answer

FIXED [State] : SUM([Sales])

Answer

FIXED [Region], [State] : SUM([Sales])

An analyst needs to create a calculation that shows the average sales for each customer, regardless of what other dimensions (like Region or Product Category) are shown in the visualization.The value should remain fixed for each customer.Which type of calculation should be used to achieve this?

An analyst needs to create a calculation that shows the average sales for each customer, regardless of what other dimensions (like Region or Product Category) are shown in the visualization.
The value should remain fixed for each customer.
Which type of calculation should be used to achieve this?