How can I filter a dashboard to show the most recent day?

You can use date tokens (like $c9_today, $c9_thisweek etc. https://www.knowi.com/docs/cloud9QL.html#DateTokens) that we'll automatically replace at run time. For example:     "createdAt" : {         "$lt" : "$c9_today+1d"       } (you can either add that into the filters if you using the query builder or modify the query with it).