Hi Domo friends,
I want to query data via workbench but the backend table I'm pulling from is unnecessarily big. I want to limit the date from to the last 30 days from the current day and have it replaced every day. My inclination is something like:
`select * from 'data_source' where 'day' = {!lastvalue:day!} - 30
but I'm not sure what the proper syntax is. Please let me know if I need to include more information here, thanks!