Hi Everyone,
I'm very new to Tableau. I have created a calculation [DIFF] to return the difference between two date&time columns by the formula below:
DATEDIFF('minute',[Time1], [Time2])
Now I want to calculate the number of records that has a value less than -6?
This is what I wrote but didn't work. Please tell me what's wront?
IF (SUM([DIFF])) <=-6
THEN(SUM([Number of Records]))
END
Hi Penn,
Can you try with below:
SUM
(
IF ([DIFF])<=-6 THEN ([Number of Records]) END
)