Reference Dashboard Filter in Custom Measure Custom Filter

I have a dashboard that filters all clients that were enrolled in a program through a certain date range, and then a custom measure that should count the number of unique clients with a move-in date in that reporting period. The calc looks like this:

4808cc72-6128-4fa8-8dbb-c5bde397b39d.png

The issue is that the dashboard filter looks at all clients with an enrollment during the period, meaning that if someone was enrolled and had a move-in date 1 year ago and is still active, they are counted by this calculation. What I really need is for ${entry_screen.move_in_date} to be between the reporting period start and end date. Is is possible to reference those dashboard filter values in a custom measure’s custom filter? My account does not have access to LookML

1 0 309
0 REPLIES 0
Top Labels in this Space
Top Solution Authors