Hello! I hope this is a simple issue, but I have been struggling trying to figure out the solution within Metabase.
I have a date output of YYYY-MM-DD-HH. I have created a new column that takes off hours, so it is just YYYY-MM-DD. I want to create a filter that, if my date is the same as today's date, it pulls those values. The "now" function doesn't seem to be quite what is needed for this. Any suggestions?
Bonus points for a second question that I haven't looked into yet. If the filter pulls a value, I want to pull the last 24 hours of data for that item. Is there an obvious way to do that? Maybe datetimeSubtract?