Was this page helpful?
Yes No
Have a comment? Please leave it here. Thanks for your feedback!
All Tableau Help > Tableau Desktop and Web Authoring Help > 
Applies to: Tableau Desktop

Materialize Calculations in Your Extracts

You can use the Compute Calculations Now option to materialize calculations in your extract. When calculations are materialized, certain calculations are computed in advance and its values stored in the extract. Depending on the complexity of the calculations used in your extract, this can potentially speed up future queries by allowing Tableau to compute certain calculations in advance. Tableau can then use the precomputed value rather than computing the value each time a query against a calculation is made.

If the formula for a calculation that Tableau has already materialized changes or the calculation is deleted from the data source, the materialized calculation is removed from the extract until you use the Compute Calculations Now option again.

When to materialize calculations

You should not use the Compute Calculations Now option for all your extracts. Instead, try this option only when the query performance of your extract is slow as a result of complex calculations, such as string manipulations and regular expressions.

Materialize calculations

To materialize calculations in your extract, do the following:

  1. In Tableau Desktop, select the extract data source from the Data menu.

  2. Select Extract > Compute Calculations Now.

Calculations that cannot be materialized

The following calculations cannot be materialized: