Deriving partition filter from timestamp

[kendru]

I have a table in Databricks that is a time series of sensor readings. The table is partitioned on a column called `year_month` with values in the format `yyyymm`. This field is derived from an `event_datetime` timestamp that is present on every row, and I am trying to figure out how to add a calculated filter on the partition column whenever there is a filter applied to `event_datetime`. For example, if the user filters on `event_datetime_date` is in the past 90 days, I’d like to be able to add a filter such that the year_month is between, say `202110` and `202204`. Is this possible to do in LookML?