The avatar for @jurian
Jurian Baas
This is my work account, my private observable account is @jurb
Published
Edited
Jul 26, 2022
Fork of Google Sheets Starter
•
1 fork
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
// TODO: visualisation with answers to subquestions (maybe left/right, pricing table, slope chart)
Insert cell
Insert cell
Insert cell
Type JavaScript, then Shift-Enter. Ctrl-space for more options. Arrow ↑/↓ to switch modes.

Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
// viewof type = Inputs.radio(["Team", "Individu"], {label: "Resultaten per"})
Insert cell
Insert cell
antwoordenForm1 = d3.csv(getCsvUrl('https://docs.google.com/spreadsheets/d/1o-B2c5xR93jW2C55CSbOkpx6AwAQ4AJ-Y11qYS0AmeU/edit#gid=877452206'), d3.autoType)
Insert cell
antwoordenForm2 = d3.csv(getCsvUrl('https://docs.google.com/spreadsheets/d/1o-B2c5xR93jW2C55CSbOkpx6AwAQ4AJ-Y11qYS0AmeU/edit#gid=526105434'), d3.autoType)
Insert cell
antwoordenForm3 = d3.csv(getCsvUrl('https://docs.google.com/spreadsheets/d/1o-B2c5xR93jW2C55CSbOkpx6AwAQ4AJ-Y11qYS0AmeU/edit#gid=2083552745'), d3.autoType)
Insert cell
antwoordenForm4 = d3.csv(getCsvUrl('https://docs.google.com/spreadsheets/d/1o-B2c5xR93jW2C55CSbOkpx6AwAQ4AJ-Y11qYS0AmeU/edit#gid=2033610729'), d3.autoType)
Insert cell
antwoordenImport = [...antwoordenForm1, ...antwoordenForm2, ...antwoordenForm3, ...antwoordenForm4]
Insert cell
Insert cell
Insert cell
Type JavaScript, then Shift-Enter. Ctrl-space for more options. Arrow ↑/↓ to switch modes.

Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
antwoordenSummary2 = antwoordenSummary.map(el => ({...el, avg_score: d3.mean(el.vragen.map(d => d.value))}))
Insert cell
antwoordenSummary2Team = antwoordenSummary2.filter(d => d.type === "Samen tijdens een teamgesprek")
Insert cell
antwoordenSummary2TeamSelected = antwoordenSummary2Team.filter(d => d.team === teamSelected)
Insert cell
Insert cell
Insert cell
Insert cell
antwoordenFlatCombinedTeamSelected = [...antwoordenSummaryFlatTeamSelected, ...antwoordenSummary2TeamSelected]
Insert cell
Insert cell
Insert cell
Insert cell
radarConfigDefault = {
return {
h: 400,
w: 400,
margin: { top: 50, bottom: 50, left: 125, right: 125 },
maxValue: 1, //What is the value that the biggest circle will represent
levels: 5, //How many levels or inner circles should there be drawn
roundStrokes: true, //If true the area and stroke will follow a round path (cardinal-closed
strokeWidth: 2, //The width of the stroke around each blob
opacityCircles: 0.1, //The opacity of the circles of each blob
labelFactor: 1.1, //How much farther than the radius of the outer circle should the labels be placed
wrapWidth: 60, //The number of pixels after which a label needs to be given a new line
opacityArea: 0.35, //The opacity of the area of the blob
dotRadius: 4, //The size of the colored circles of each blog
axisFormat: d3.format(".0f"),
tooltipFormat: d3.format(".1f")
};
}
Insert cell
Insert cell
Insert cell
import { aq, op } from '@uwdata/arquero'
Insert cell
import { SummaryTable } from "@observablehq/summary-table"
Insert cell

One platform to build and deploy the best data apps

Experiment and prototype by building visualizations in live JavaScript notebooks. Collaborate with your team and decide which concepts to build out.
Use Observable Framework to build data apps locally. Use data loaders to build in any language or library, including Python, SQL, and R.
Seamlessly deploy to Observable. Test before you ship, use automatic deploy-on-commit, and ensure your projects are always up-to-date.
Learn more