How do I add a date filter to a text stored as meta value?

omarzubair · February 19, 2020, 6:23am

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?

flamber · February 19, 2020, 1:20pm

Hi @omarzubair
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.