re:dashの各種統計値を取得するSQL - Qiita

デフォルトで用意されているData sourceの「re:dash metadata」で取れる各種統計値です。 日別のクエリ数、閲覧数 SELECT to_date(to_char(created_at,'YYYY-MM-DD'),'YYYY-MM-DD') AS created_at, SUM(CASE WHEN action = 'execute' THEN 1 ELSE 0 END) AS execute, SUM(CASE WHEN action = 'view' THEN 1 ELSE 0 END) AS view FROM events WHERE created_at BETWEEN NOW() - interval '6 month' AND NOW() GROUP BY 1 ORDER BY 1 SELECT '<a href="/dashboard/' || d.slu