The avatar for @adityawarmanfw
Fidocia Wima Adityawarman
Product, analytics, viz. Product analyst @ShowwcaseHQ.
Public
Edited
Aug 12, 2024
1
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
moonboard_formatted.parquet
WITH unnested AS (
SELECT
moonboard_version,
problem_id,
name,
grade,
starts,
ends,
unnest(holds) AS holds,
FROM "moonboard_formatted"
WHERE is_benchmark
AND moonboard_version = ${ver}
)
SELECT
moonboard_version,
problem_id,
name,
grade,
holds,
holds[1] AS letter,
holds[2:]::int AS number,
CASE
WHEN holds = ANY(starts) THEN 'start'
WHEN holds = ANY(ends) THEN 'end'
END AS moves
FROM unnested;

Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell

Purpose-built for displays of data

Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.
Learn more