Freelance web app developer with a focus on data vis and science communication.
file = FileAttachment("psm_events_may2023.csv")
raw = file.csv({array: true});
rows = raw.map(row => ({
date: new Date(row[0]).toISOString(),
user: row[1],
event: row[2],
error: parseInt(row[3], 10) || null
})).filter(row => !row.user.includes('@pleasesign.me') && row.user !== 'c.ydenberg@graphos.ca')
errorEvents = rows.filter(row => row.error)
users = rows.reduce((acc, row) => {
if (acc.includes(row.user)) {
return acc;
}
return [...acc, row.user];
}, []);
usersAuthenticated = users.filter(user => rows.find(row => row.user === user && row.event !== 'run'))
usersBeyond = users.filter(user => rows.find(row => row.user === user && row.event === 'create-slip'))
table = [
['', 'Gmail', 'Workspace', 'Total'],
['Users', users.filter(u => u.includes('@gmail.com')).length, users.filter(u => !u.includes('@gmail.com')).length, users.length],
['Authenticated', usersAuthenticated.filter(u => u.includes('@gmail.com')).length, usersAuthenticated.filter(u => !u.includes('@gmail.com')).length, usersAuthenticated.length],
['Send signing request', usersBeyond.filter(u => u.includes('@gmail.com')).length, usersBeyond.filter(u => !u.includes('@gmail.com')).length, usersBeyond.length]
];
workspaceSuccesses = usersBeyond.filter(u => !u.includes('@gmail.com'))
sentByExpandMentoring = rows.filter(row => row.user === 'hello@expandmentoring.com' && row.event === 'create-slip')
workspaceDropouts = usersAuthenticated.filter(u => !u.includes('@gmail.com') && !usersBeyond.includes(u))
workspaceSent = usersAuthenticated.filter(u => !u.includes('@gmail.com') && usersBeyond.includes(u))
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.
