Combining Multiple Slices Using Context View for Conditional Filtering

[Tom6]

Hi everyone,

I'm looking for guidance on efficiently combining multiple slices into a single slice using context view for conditional filtering.

I have different views where tasks should be filtered based on specific conditions. For instance, in the "KB_Not_Started" view, I want tasks with the status "Not Started", and similarly for other views.

My attempt to merge these conditions into a single slice using context-based filtering hasn't been successful so far. Any advice on optimizing filtering conditions based on the context view without creating separate slices for each view would be really helpful!

Here's a sample expression I've tried to incorporate this logic:

AND(
OR(
CONTEXT("View") = "KB_Not_Started",
CONTEXT("View") = "KB_In_Progress",
CONTEXT("View") = "KB_Completed"
),
OR(
IF(
CONTEXT("View") = "KB_Not_Started",
[Status] = "Not Started",
TRUE
),
IF(
CONTEXT("View") = "KB_In_Progress",
[Status] = "In Progress",
TRUE
),
IF(
CONTEXT("View") = "KB_Completed",
[Status] = "Completed",
TRUE
)
),
OR(
ISBLANK(Current_User_Filter[Assigned To]),
IN([Assigned To], Current_User_Filter[Assigned To])
)
)

Thanks!