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:
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]))
Can you try with below:
IF ([DIFF])<=-6 THEN ([Number of Records]) END