Parameter =TODAY()-1 in a SQL WHERE, pinned, then saved as reports_<date>.xlsx. A 1:58 full-HD video recorded on the real ATX AnalyticsTable application, part of the automated excel and pdf reports tutorials.
Most morning reports are the same query with yesterday's date typed in by hand, copied into Excel and saved under a new name. This tutorial builds that report once so it never needs typing again.
A parameter named yesterday is defined as =TODAY()-1 in the format SQL dates use, YYYY-MM-DD. It goes into the SQL as WHERE order_date = '${yesterday}' — the value is filled in before DuckDB sees the query — and into the export file name as reports_${yesterday}, so each day writes its own dated workbook.
The clip also shows one detail that trips people up: a result pinned from the Get Data menu has no header row, so the column names are switched on under Query Binding › Query Properties before the export. Add a schedule to the export and the report arrives before you do.
Settings → Parameters → Add parameter → yesterday → Get Data → Empty Grid → SQL → Editor → WHERE ${yesterday} → Run → Sheet → Get Data → Static → Insert Table → Right-click → Query Binding → Query Properties → Export → Excel → Flat file → reports_${yesterday} → Export now
This site needs JavaScript for the full experience. Every page above is reachable without it.