Filter suggestions and conditionally_filter with unless

[jhyuneb]

Our Explores have a conditionally_filter where by default it will only show values with a createdDate of 30 days or newer unless the user already has a createdDate filter specified (so they can query for data older than 30 days. E.g.

explore: my_explore {
    conditionally_filter: {
        filters: [createdDate_date: "30 days"]
        unless: [createdDate_date]
    }
}

However, when one adds an explicit createdDate filter with a different value, and adds an additional field to filter on, if one clicks on that filter field to see suggestions they only see values limited to the default conditionally_filter and not the user specified createdDate filter.

So imagine if I have a table and today's date is 2024-12-30:

name	createdDate
Jack	2024-12-15
Jill	2024-11-01

And in my explore I add a filter on name - if I click on the filter suggestions I will only get Jack as a suggestion even if I add a createdDate filter to my explore with a time range that would include Jill. The suggestion query ignores it.

[GavinW · Accepted solution]

Are you seeing this behaviour in the context of a dashboard, or an explore? (I see you mention explores in your post, just confirming)

Dynamically updating filter suggestions based on changes to filters is only a functionality that is available in the context of linked filters in dashboards, I don't believe it is expected to work at the explore level.

[jhyuneb]

I am seeing it in both an explore and dashboard. However, in the dashboard I did not have the date field and dependent field linked in the dashboard filter configuration. When I link them it appears to work!

It is great that it does appear to work when manually linked in the dashboard ui. However, it is confusing since, from a LookML modeling standpoint, they are already "linked" in the LookML. If it is not expected to work in an explore, is there a way for the dashboard to automatically recognize the relationship between the fields as specified in the LookML?

[GavinW]

I don't believe there is a way to make it work at explore level, although I can certainly the value in doing so.