Question

Reference Dashboard Filter in Custom Measure Custom Filter

  • 14 October 2022
  • 0 replies
  • 65 views

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:

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

 


This topic has been closed for comments