thinQmaster Virtual testing partner Adaptive practice exams that find your weak spots and drill them. Every answer explained. From $69
Enroll

thinQmaster

Find your exam

Five questions free, before you decide.

Step 1 · choose a vendor

In one of our camps? Your practice exams come with the tuition — they are on your study page already.

Data & Analytics · Foundational

Calculated Field (Tableau)

A new Tableau field created from a formula using functions, operators and other fields.

Definition

Calculations can be row-level, aggregate, LOD or table calculations. You cannot mix aggregate and non-aggregate arguments in one expression.

Example

IF [Profit] > 0 THEN 'Profitable' ELSE 'Loss' END

Exam tip

The 'cannot mix aggregate and non-aggregate arguments' error is fixed by aggregating both parts or using an LOD.

Related terms