O'Reilly logo

Learning Tableau by Joshua N. Milligan

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Ad hoc calculations

Tableau 9.0 introduced a new way of creating and using calculations. Ad hoc calculations add calculated fields to shelves in a single view without adding fields to the Data window.

Let's say you have a simple view that shows the price per renter, like this:

Ad hoc calculations

What if you wanted to quickly highlight any renters who had a contract of more than $3,000? One option would be to create an ad hoc calculation. To do so, simply double-click on an empty area of the Columns, Rows, or Measure Values cards or on the empty space of the Marks shelf and then start typing the code for a calculation. In this example, we've double-clicked on the empty ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required