Ask for last week reports

Get Help
1

Hello,

I am completely new at Metabase. I want to configure an automatic report with last week data.

I have this MySQL SELECT that looks well:

SELECT
  DATE,
  content
FROM
  tasks
WHERE
  DATE > '2024-10-14'
  AND DATE < '2024-10-20'

How could I automate the week date? If today is 2024-10-24, the last week info is from 2024-10-14 (monday) to 2024-10-20 (sunday).

Is there any variable could I use for this?

I will appreciate any help. Best regards.

2

I would do WHERE {{date}} and then date would be a relative filter Field filters for SQL questions