WITH
funnelTrack_RawEvents AS (
    SELECT
        dt AS EventDate,
        uid,
        MAX(action = 'feed_opened_full') AS geo_widget_added,
        MAX(action = 'geo_widget_clicked') AS geo_widget_clicked
    FROM
        stat.funnelTrack
    --    JOIN exp_users USING(uid)
    WHERE dt >= '2024-08-10'
  AND appVersion >= 2007831
  AND region in ('global', 'ru')
  AND (deviceType = 1 AND appVersion % 2 = 1)
        AND dt < today()
        AND action IN ('feed_opened_full', 'geo_widget_clicked')
    GROUP BY
        EventDate, uid
),
users AS (
    SELECT
        uid,
        min(EventDate) filter (where geo_widget_added = 1) AS geo_widget_added,
        min(EventDate) filter (where geo_widget_clicked = 1) AS geo_widget_clicked
    FROM
        funnelTrack_RawEvents
    GROUP BY
        uid
)
SELECT
dateDiff('day', geo_widget_added, geo_widget_clicked) AS day_,
count(*) as n
FROM users
GROUP BY 1
HAVING day_ >= 0
ORDER BY 1

-- SELECT
--     dateDiff('day', e1.EventDate, cm.EventDate) AS day_,
--     -- uniqExact(e1.uid) AS users,
--     sum(cm.geo_widget_clicked) AS clicked,
--     ROUND(sum((cm.geo_widget_clicked AND cm1.geo_widget_clicked) ? 1 : 0) / clicked, 2)  AS RT_widget_clicked,
--     sum(cm.geo_widget_added) AS added
-- FROM
--     funnelTrack_RawEvents cm
-- LEFT JOIN
--     funnelTrack_RawEvents cm1
--     ON cm.uid = cm1.uid AND cm.EventDate = cm1.EventDate + INTERVAL 1 DAY
-- JOIN
--     users e1 ON cm.uid = e1.uid
-- WHERE
--     e1.EventDate <= cm.EventDate
-- GROUP BY
--     1
-- ORDER BY
--     day_
-- LIMIT 90;