An example dashboard to show how to get data from other FlipSide queries with the LiveQuery functionality.
The base query aggregates daily activity on the Uniswap V3 router.
Router address: 0xe592427a0aece92de3edee1f18e0157c05861564
Instead of duplicating the Base Query to get the Totals, with LiveQuery we fetch the Base Query results and calculate the totals of interest.
This avoids the re-run of the Base Query.
livequery.live.udf_api('https://flipsidecrypto.xyz/api/v1/queries/{query_id}/data/latest') as response
The query_id can be taken directly from the browser address bar when editing your target query
query_id
The example shown here is meant as basic how-to, as there is no gains by using LiveQuery in this example.
For long and resource consuming queries there will be efficiency gains by not running the same query multiple times.