New users | |
|---|---|
1 | 17070 |
AzinNew users
Updated 10 days ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
›
⌄
WITH T1 AS
(SELECT
CASE
WHEN
INPUTS[0]['type'] = 'private' OR INPUTS[1]['type'] = 'private' OR INPUTS[2]['type'] = 'private' OR INPUTS[3]['type'] = 'private' THEN 'private' ELSE 'public'END AS Typee ,
CASE
WHEN INPUTS[0]['value'] like '%aleo%' THEN INPUTS[0]['value']
WHEN INPUTS[1]['value'] like '%aleo%' THEN INPUTS[1]['value']
WHEN INPUTS[2]['value'] like '%aleo%' THEN INPUTS[2]['value']
WHEN INPUTS[3]['value'] like '%aleo%' THEN INPUTS[3]['value']
WHEN INPUTS[4]['value'] like '%aleo%' THEN INPUTS[4]['value']
WHEN INPUTS[5]['value'] like '%aleo%' THEN INPUTS[5]['value'] END AS User ,
*
FROM
aleo.core.fact_transitions
WHERE
SUCCEEDED = 'TRUE'
and
Typee = 'public'),
users AS
(SELECT
min(BLOCK_TIMESTAMP) AS Datee,
USER
FROM
T1
GROUP BY 2)
SELECT
COUNT(*) AS "New users"
FROM
users
WHERE
Datee > Current_date - 8
Last run: 10 days ago
1
9B
4s