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.