Mastering Tableau 2018.1, Second Edition 7.7: Creating Ad-hoc Calculations

The video tutorial explains how to create inline calculations in Tableau, also known as local or typing calculations. It covers the steps to create these calculations directly on the canvas, highlighting their advantages in terms of time optimization. However, it also discusses the limitations, such as the inability to reuse these calculations across different worksheets. The tutorial contrasts inline calculations with global calculations created using calculated fields, which can be reused across multiple worksheets. The video concludes with a brief overview of the next topics to be covered.

What is a key characteristic of inline calculations in Tableau?

• They are reusable across multiple worksheets.

• They are automatically saved as global calculations.

• They are created directly on the canvas.

• They require a separate calculated field.

Where can you perform inline calculations in Tableau?

• Only in the data pane.

• Only in the dashboard view.

• In the columns, rows, and marks card.

• Exclusively in the calculated field editor.

What is an advantage of using inline calculations?

• They provide more complex functions than calculated fields.

• They can be shared across different Tableau projects.

• They optimize time by avoiding the creation of calculated fields.

• They are automatically saved for future use.

Why might you choose a calculated field over an inline calculation?

• To perform calculations that are only needed once.

• To ensure the calculation is local to a single worksheet.

• To reuse the calculation across multiple worksheets.

• To avoid using the marks card.

What is a limitation of inline calculations?

• They are not visible in the data pane.

• They cannot be used in the marks card.

• They cannot be reused in other worksheets.

• They require complex syntax.