Beastmode with adjustable date & null filter
I am recreating a SQL query as a card in Domo. I need it to show transactions where:
- the OrderDate is before a specific date (that changes each time the report is run) and the SoldDate is NULL
- the SoldDate is after a certain date
Is it possible to make a Beastmode that can do this and show an adjustable date filter in the quick filters without the user needing to go into the analyzer? I have quick filters set up now, but with the current method, the user needs to run it twice to get all the transactions. See attached for what I have now and the original SQL query.