Forum Discussion

jostnachs's avatar
jostnachs
Helper IV
1 year ago

Slicer issue

Hi All.... I have a requirement i am struggling with...   I have logic as below as a slicer to divide my activities.    But the problem is if the activity followupstartdate is 5th feb and t...
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi jostnachs ,
You can try the following code

 

DueStatus = 
VAR TodayDate = TODAY()
VAR ClosedDate = V_DimActivities[FollowupStartDate]
VAR ClosedStatus = V_DimActivities[ClosedStatus]
VAR DaysDifference = DATEDIFF(ClosedDate,TodayDate,DAY)
RETURN
IF(
    ClosedStatus <> BLANK() && (ClosedStatus = "S" || ClosedStatus = "U"),
    "Closed",
    IF(
        ClosedStatus <> BLANK() && ClosedStatus <> "S" && ClosedStatus <> "U",
        IF(
            DaysDifference > 7,
            "Open & 7+days past due" ,
            IF(
                DaysDifference >= 0,
                "Open & Due now"
            )
        )
    )
)

 

Turn on multi-select in slicer settings


Final output

 

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly