Tableau-Desktop-Found Connecting to and Preparing Data Practice Question
Exhibit
{"error": "Invalid usage of aggregate and non-aggregate fields", "calculation": "[Sales] / [Target]", "target_type": "Dimension"}Refer to the exhibit. You are trying to create a calculated field for sales performance. Why is this formula failing?
⚠ Common exam trap
Candidates often try to subtract a raw row value from an aggregated sum, forgetting that Tableau requires all operands in a calculation to be at the same aggregation level.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Mixing aggregate and non-aggregate fields is illegal.
In Tableau, you cannot mix aggregate and non-aggregate values in a calculation unless all non-aggregate fields are wrapped in an aggregation function. This ensures that the calculation is performed consistently across the entire dataset. Recognizing this rule is vital for creating accurate ratios and percentages, as calculations that mix grains often result in unexpected errors or logically incorrect outputs that can ruin dashboards.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
The fields must be joined in the physical layer first.
Why it's wrong here
The error is related to the calculation logic, not the data source structure. Even if the tables were joined, mixing aggregate and non-aggregate fields would still trigger this error. The problem lies strictly in the mathematical syntax used within the calculated field definition.
- ✗
Calculations cannot reference dimension fields.
Why it's wrong here
Calculations can reference any field, including dimensions. The issue here is that the dimension needs to be aggregated (e.g., using SUM or MIN) so that it matches the aggregate grain of the 'Sales' measure, allowing the math to resolve correctly at the appropriate level.
- ✓
Mixing aggregate and non-aggregate fields is illegal.
Why this is correct
Tableau requires consistent aggregation levels in expressions. Since 'Sales' is a measure (aggregated) and 'Target' is a dimension (non-aggregated), you must wrap 'Target' in an aggregation like SUM or AVG to ensure the math evaluates correctly. Failure to do this prevents the formula from producing a valid result.
- ✗
The data source requires a live connection.
Why it's wrong here
The connection type has no bearing on calculation syntax. Whether you are using a live connection or an extract, the rule regarding mixing aggregate and non-aggregate fields remains the same. This is a fundamental constraint of the calculation language, regardless of how the data is stored.
About these practice questions
This Tableau-Desktop-Found question is part of Courseiva's 126-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Tableau (Salesforce) exam blueprint
This Tableau-Desktop-Found practice question is part of Courseiva's free Tableau (Salesforce) certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the Tableau-Desktop-Found exam.