Metabase Analytics Query

1SELECT
2  DATE_TRUNC('week', created_at) AS week,
3  COUNT(*) AS signups,
4  COUNT(*) FILTER (
5    WHERE plan = 'paid'
6  ) AS paid_signups,
7  ROUND(
8    100.0 * COUNT(*) FILTER (
9      WHERE plan = 'paid'
10    ) / COUNT(*),
11    1
12  ) AS conversion_rate
13FROM
14  users
15GROUP BY
16  week
17ORDER BY
18  week DESC;