Public
Edited
Jun 6, 2023
dec = FileAttachment("202212@2.xlsx").xlsx()
dec2 = sheet1.map((d) => ({...d, month: "December"}))
sheet1 = dec.sheet("Curie Coach Time Spent on Sleep")
dec1 = sheet1.map(d => ({Patient_ID: d.A, Date: d.B, Services: d.C, Time_Spent: d.D, Total_Time: d.E, Month: "December"}))
jan = FileAttachment("202301.xlsx").xlsx()
jan2 = sheet2.map((d) => ({...d, month: "January"}))
jan2.map((d) => ({
dates: d3.timeParse("%a %b %-d, %Y %H:%M %p")(jan2, (d) => d.C)
})
jan1 = sheet2.map(d => ({Patient_ID: d.B, Date: d[f(C)], Services: d.D, Time_Spent: d.E, Total_Time: d.F, Month: "January"}))
sheet2 = jan.sheet("Curie Coach Time Spent on Sleep")
feb = FileAttachment("202302.xlsx").xlsx()
feb2 = sheet3.map((d) => ({...d, month: "February"}))
sheet3 = feb.sheet("Curie Coach Time Spent on Sleep")
feb1 = feb2.map(d => ({Patient_ID: d.B, Date: d.C, Services: d.D, Time_Spent: d.E, Total_Time: d.F, Month: "February"}))
mar= FileAttachment("202303.xlsx").xlsx()
sheet4 = mar.sheet("Curie Coach Time Spent on Sleep")
mar2 = sheet4.map((d) => ({...d, month: "March"}))
mar1 = mar2.map(d => ({Patient_ID: d.B, Date: d.C, Services: d.D, Time_Spent: d.E, Total_Time: d.F, Month: "March"}))
apr = FileAttachment("202304.xlsx").xlsx()
sheet5 = apr.sheet("Curie Coach Time Spent on Sleep")
apr2 = sheet5.map((d) => ({...d, month: "April"}))
apr1 = apr2.map(d => ({Patient_ID: d.B, Date: d.C, Services: d.D, Time_Spent: d.E, Total_Time: d.F, Month: "April"}))
data1 = d3.merge([dec1, jan1, feb1, mar1, apr1])
data1
Type Table, then Shift-Enter. Ctrl-space for more options.
data1
X*
—
Y*
—
Color
—
Size
—
Facet X
—
Facet Y
—
Mark
Auto
Type Chart, then Shift-Enter. Ctrl-space for more options.
removePatient = data.filter((d) => d.patientID)
import {Streamgraph} from "@d3/streamgraph"
chart = Streamgraph(data1, {
x: d => d.date,
y: d => d.time_spent,
z: d => d.patient_id,
yLabel: "Time Spent",
width,
height: 500
})
import {LineChart} from "@d3/line-chart"
flart = LineChart(data1, {
x: d => d.date,
y: d => d.time_spent,
yLabel: "Time Spent (min)",
width,
height: 500,
color: (d) => d.patient_id
})
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.
