Hi. I'm assuming you want to express this logic as a single calculated field? Have you tried something like this (example for the start type calculation)
IF (ISNULL([Start Actual]) AND [Start Forecast] < TODAY())
IF DATEDIFF('day',TODAY(),[Start Forecast]) < 7 THEN '0-7'
ELSEIF DATEDIFF('day',TODAY(),[Start Forecast]) < 14 THEN '8-14'
Thanks for the assist, however the formula returns 0 for everything. i have created a formula (refer attached). based on the formula [Start Fcst (Count)] should i create another one to flag based on number of day if this is the case i will have to do 2 formula for each date type and there are 14 in total.
INT(If DATEDIFF('day', TODAY(), [Start Forecast]) <= 0 and ISNULL([Start Actual])= TRUE
Then [Start Forecast]
tableau 1.PNG 46.8 KB
The calculation returns nothing because there are no rows that satisfy the first conditions of your required calculation:
ISNULL([Start Actual]) AND [Start Forecast] < TODAY()
Could this be OR?
Regards your calculation, it depends if you need to display the actual DATEDIFF value or just aggregate the number of rows in each category (0-7, 8-14, etc). If it's the latter, then you can handle it in a single calculation.