Public
Edited
Mar 8, 2023
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
data = 'contributor, reason\n' + latestPraiseTable.map(item => (`${item.contributor}, ${item.reason}`)).join('\n')
Insert cell
praiseDb
SELECT
useraccounts.name as contributor,
reason,
score
FROM praises
LEFT JOIN useraccounts ON praises.receiver = useraccounts._id
WHERE praises.createdAt > ${getPreviousPeriod(periodSelect).endDate.toISOString()} AND praises.createdAt <= ${periodSelect.endDate.toISOString()}
ORDER BY score DESC
LIMIT 100

Insert cell
Insert cell
Insert cell
Insert cell
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