Nombre de visites au cours des 90 derniers jours

Type de graphique : Tableau de bord

WITH tab1 AS(SELECT
id,
EXTRACT(DAY FROM timestamp - NOW()) as diff,
place_id
FROM log
WHERE action_code='CHECK_IN')

SELECT
COUNT (DISTINCT id) as nb_submissions
FROM tab1
WHERE place_id = '$param1$' AND diff<91
CODE

 

Nombre de visites au cours des 90 derniers jours

Type de graphique : Tableau de bord

WITH tab1 AS(SELECT
id,
EXTRACT(DAY FROM timestamp - NOW()) as diff,
place_id
FROM log
WHERE action_code='CHECK_IN')

SELECT
COUNT (DISTINCT id) as nb_submissions
FROM tab1
WHERE place_id = '$param1$' AND diff<31
CODE