我想写一个图表来显示firebase中的活跃用户
我写了这段代码
SELECT event_date, COUNT(DISTINCT user_pseudo_id) AS user_count
FROM `mark-3314e.analytics_197261162.events_*`
WHERE _TABLE_SUFFIX BETWEEN FORMAT_DATE('%Y%m%d', DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)) AND FORMAT_DATE('%Y%m%d', CURRENT_DATE())
AND event_name = 'session_start'
GROUP BY event_date
ORDER BY event_date ASC
这是我的回答
Row event_date user_count
1 20190617 1
2 20190621 3
有没有办法用之前的数据填补21到17之间缺失的日期?像这样:
event_date user_count
20190617 1
20190618 1
20190619 1
20190620 1
20190621 3
https://stackoverflow.com/questions/56716782
复制相似问题