How do I add a date filter to a text stored as meta value?
I have read-only access to the database. I’m trying to find an answer for the ‘number of people who were up for renewal in a given period?’ The information is available as text inside a meta value. How do I get through this?
If you want to search a text column, then your filter should just be a Text filter, so you would write the date manually.
If you want to get smarter filters with dropdowns, then you would have to convert your data to a more correct structure that Metabase would be able to understand.