Filter Delegate Intermediate - What about now (1)?

When you enrich filter delegate by also using local filters you can identify a group with certain characteristics back in time, and examine those people/products/customers in another timeframe.

If you're not familiar with the basics of filter delegate, please refer to this article before continuing reading.

HR Data Example

Here's a simple setup that uses filter delegate to identify the people who we're absent for some reason 13-24 months back - and then examine what their absence pattern is in a more recent period of time (1-12 months back):

So the slicer on the left-hand side has a local filter set to 13-24 months back in time ,and it has a filter delegate setup that delegates the employee dimension.

The graph and the table on the right-hand side has local filters set to 1-12 months back in time.

So when you click Undefined Sick - you identify the peoply who called in sick with that reason 13-24 months back - and those people are the filter that is passed so you can examine what their pattern is in a more recent period (1-12 months back).