flipsidecryptoKSM Analyst Count copy
9
1
2
3
4
5
6
7
›
⌄
-- forked from KSM Analyst Count @ https://flipsidecrypto.xyz/edit/queries/15714f8e-0bc0-48aa-ae87-fc0dc8485eeb
select new + active + returned + churned + inactive as total_users
from BI_ANALYTICS.USER_METRICS.DATA_STUDIO_DAILY
where date_day = (select max(date_day) from BI_ANALYTICS.USER_METRICS.DATA_STUDIO_DAILY)
Run a query to Download Data