I’m wondering if there’re way other than groovy to get filter like “past 7 days” to work? Found this question back in 2017 about

select count(*) as cnt from  log where date >= DATE_SUB(NOW(),INTERVAL 1 HOUR);

Function

now()

is supported with value of milliseconds epoch value.

Thanks! 🙏