flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
Action Distribution Yieldly
nits
Action Distribution Yieldly
Updated 2022-03-29
Copy Reference
Fork
9
1
2
3
4
5
6
7
8
9
›
⌄
SELECT
action
,
count
(
*
)
as
total_events
from
(
SELECT
try_base64_decode_string
(
tx_message
:
txn
:
apaa
[
0
]
::
string
)
as
action
,
*
from
algorand
.
application_call_transaction
where
app_id
=
'596947890'
)
where
action
is
not
NULL
GROUP
by
1
2
desc
limit
100
Results
Run a query to Download Data