flipsidecryptoAll Tests, Near, Current
Updated 2023-10-20
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
›
⌄
with test_data as (
select
*,
max(max_block) over (order by test_timestamp) -
min(min_block) over (order by test_timestamp) + 1 as total_blocks_at_time
from
bi_analytics.core.fact_data_observability_results
),
proportions as (
select
blockchain,
test_name,
test_timestamp,
blocks_impacted_count / total_blocks_at_time as proportion_impacted
from
test_data
)
select
blockchain,
test_name,
proportion_impacted as "%_INCOMPLETE",
1 - proportion_impacted as "%_COMPLETE",
max(test_timestamp) as last_test_timestamp
from proportions
where blockchain = 'near'
group by 1,2,3
order by 1, 2
Run a query to Download Data