Tableau Exam Prep Unit 4

Which of the following calculations will produce errors while concatenating fields? Select two.

- "Location: " + [City] & [State] - "Location: " + [City] + [State] + [Zip Code]

What are the five marks in the marks card?

- Color - Size - Text - Detail - Tooltip

Which locations within the interface can a calculation editor be generated? Select all that apply.

- Data Source Page - Data Pane - Analysis Menu

This view shows a single mark for Profit and Sales, as automatically aggregated by Tableau. If the Region field is added to Detail on the Marks card, what result would you expect?

A mark for each region

Use a parameter in a view to:

Add interactivity and flexibility to a report.

Which of the following statements is true for a parameter?

Can be used in a calculated field

After editing a calculation, what action do you take to preview how the edited calculation will affect the data shown in a view before saving the edited calculation?

Click the Apply button in the Calculation Editor.

Which of the following date functions will allow you to find the date of the beginning of the week for any existing date value?

DATETRUNC

In addition to using autocomplete, how can you bring fields into the calculation editor or into an ad-hoc calculation?

Drag them from the view or the Data pane to the calculation.

Which of the following is NOT considered a valid scope for applying a table calculation?

Partition

Which built-in table calculation should you use if you want to see sales for three years displayed with each month's sales added to all previous months' sales?

Running Total

If you create a calculated field with the formula SUM([Profit]) / SUM([Sales]), how will Tableau perform the aggregation for the calculation?

Tableau will sum the Profit and Sales values separately for the level of detail in the view and then divide the total of Profit by the total of Sales.

Why is it helpful to give parameters actionable titles?

The title can tell the user how to use the parameter control.

After you create a calculated field that concatenates the City and State fields, what happens to the original City and State fields?

They remain in the Data pane and in the original data source.

Which quick table calculation can you use to compute the percentage change of Sales over time?

Year over Year Growth

Which of the following scenarios requires a calculated field?

You want to combine two existing fields in your data to create a new field.