Tableau-Desktop-Found Exploring and Analyzing Data Practice Question
You have a view with two dates: 'Order Date' and 'Ship Date'. You want to calculate the average time between these two dates. What is the most effective approach?
⚠ Common exam trap
Candidates often attempt to manually subtract date fields or use complex date part logic. They forget that DATEDIFF is the standard, optimized function specifically designed for calculating intervals between two dates.
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
✓
Use the DATEDIFF function
Calculating the duration between two dates is a common analytical task requiring the DATEDIFF function. This function returns the difference between two date fields based on a specified interval (e.g., days). By using this calculation, you can then aggregate the duration using an average to understand operational efficiency. This is a critical metric for supply chain and logistics analysis within many business contexts.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Use the DATEPART function for each date
Why it's wrong here
DATEPART extracts a specific part of a date, such as the month or year. It does not calculate the duration between two distinct dates. Using this would only give you information about the components of the dates, not the time difference between them.
- ✓
Use the DATEDIFF function
Why this is correct
The DATEDIFF function is designed to calculate the difference between two dates based on a defined interval like 'day'. It provides the exact duration needed to perform further aggregations like average, making it the correct tool for calculating lead times between orders and shipments.
- ✗
Subtract the two date fields directly
Why it's wrong here
Subtracting two date fields is not a valid operation in Tableau's calculated fields and will result in a syntax error. Date arithmetic must be performed using specific date functions like DATEDIFF to ensure the calculations respect the underlying calendar logic and data types.
- ✗
Create a Set for each date
Why it's wrong here
Sets are used to define groups of data members. They cannot perform arithmetic calculations on date fields to determine duration. Using sets would not allow you to calculate or aggregate the time difference between order and ship dates in any meaningful way.
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.