1.

What is a Calculated Field, and How Will You Create One?

Answer»

CALCULATED fields are created using formulas based on other fields. These fields do not exist but are created by you.

You can create these fields to:

  • SEGMENT data
  • Convert the data type of a field, such as converting a string to a date.
  • Aggregate data
  • Filter results
  • Calculate ratios

There are three main types of calculations that you can create:

  • Basic Calculations: Transform values of the data fields at the source level
  • Level of DETAIL (LOD) Expressions: Transform values of the data fields at the source level like basic calculations but with more granular access
  • Table Calculations: Transform values of the data fields only at the VISUALIZATION level

To create calculate fields:

In Tableau, navigate to Analysis>Create a calculated field. Input details in the calculation editor.
And, done!



Discussion

No Comment Found