Tableau Desktop Foundations Practice Question

A workbook contains the fields Order Date and Ship Date. You must create a calculated field that returns the number of days an order spent in transit, counting both the day the order was placed and the day it shipped. Which expression meets this requirement?

DATEDIFF('day',[Order Date],[Ship Date]) + 1
DATEDIFF('day',[Order Date],[Ship Date]) - 1
DATEDIFF('day',[Ship Date],[Order Date])
DATEDIFF('day',[Order Date],[Ship Date])

Report Issue

Answer Description

DATEDIFF returns the number of date boundaries crossed, so the difference between two identical dates is 0. To include both the start and end dates in the count, you add 1 to the DATEDIFF result. Therefore, adding 1 to DATEDIFF('day',[Order Date],[Ship Date]) produces an inclusive day count. The other expressions either reverse the arguments (producing negative values), omit the +1 (exclusive of one date), or subtract 1 (making the result too small).

Ask Bash

Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.