-
-
Save YukiGasai/82829809daa0b488fd16bc7e9c82b6c2 to your computer and use it in GitHub Desktop.
let pages = dv | |
.pages('#DailyNote') | |
.filter(p => p.date.day != undefined) | |
.filter(p => p.sleepStart != undefined) | |
.sort(p => p.date); | |
if (input.range) pages = pages.slice(input.range * -1); | |
let timeDate = pages.date; | |
const ratingData = pages.rating; | |
const sleepStart = pages.sleepStart; | |
const sleepEnd = pages.sleepEnd; | |
const sleepRatingData = pages.sleepRating; | |
const sleepStartStop = sleepStart.values.map((value, index) => { | |
return [value, sleepEnd.values[index]]; | |
}); | |
const sleepStartStopNumber = sleepStart.values.map((value, index) => { | |
let start = | |
(parseInt(value.split(':')[0]) * 60 + parseInt(value.split(':')[1])) / 60; | |
if (start > 20) { | |
start = start - 24; | |
} | |
const end = | |
(parseInt(sleepEnd.values[index].split(':')[0]) * 60 + | |
parseInt(sleepEnd.values[index].split(':')[1])) / | |
60; | |
return [start, end]; | |
}); | |
const sleepTime = sleepStartStop.map(value => { | |
let startDate = moment(); | |
const endDate = moment('2022-06-16T' + value[1]); | |
const startHour = parseInt(value[0].split(':')[0]); | |
if (startHour > 16) { | |
startDate = moment('2022-06-15T' + value[0]); | |
} else { | |
startDate = moment('2022-06-16T' + value[0]); | |
} | |
return endDate.diff(startDate, 'minutes') / 60; | |
}); | |
timeDate = timeDate.values.map(e => `${e.day}/${e.month}/${e.year}`); | |
const chartData = { | |
beginAtZero: true, | |
data: { | |
labels: timeDate, | |
datasets: [ | |
{ | |
yAxisID: 'A', | |
type: 'line', | |
label: 'Rating', | |
data: ratingData.values, | |
borderColor: ['rgb(255, 99, 132)'], | |
borderWidth: 1, | |
}, | |
{ | |
yAxisID: 'A', | |
type: 'line', | |
label: 'Sleep Duration', | |
data: sleepTime, | |
borderColor: ['rgb(54, 162, 235)'], | |
borderWidth: 1, | |
}, | |
{ | |
yAxisID: 'A', | |
type: 'line', | |
label: 'Sleep Rating', | |
data: sleepRatingData.values, | |
borderColor: ['rgb(255, 206, 86)'], | |
borderWidth: 1, | |
}, | |
{ | |
yAxisID: 'B', | |
type: 'bar', | |
label: 'Sleep', | |
data: sleepStartStopNumber, | |
backgroundColor: ['rgb(153, 102, 255, 0.2)'], | |
borderColor: ['rgb(153, 102, 255, 1)'], | |
borderWidth: 1, | |
}, | |
], | |
}, | |
options: { | |
tooltips: { | |
callbacks: { | |
label: function (t, d) { | |
return 'FFFF'; | |
}, | |
}, | |
}, | |
scales: { | |
A: { | |
type: 'linear', | |
position: 'left', | |
beginAtZero: true, | |
min: 0, | |
}, | |
B: { | |
type: 'linear', | |
position: 'right', | |
max: 13, | |
min: -3, | |
ticks: { | |
fontSize: 40, | |
count: 17, | |
maxTicksLimit: 20, | |
callback: function (value, index, ticks) { | |
if (value < 0) { | |
value = 24 + value; | |
} | |
let minutes = value * 60; | |
let hours = Math.floor(minutes / 60); | |
minutes = minutes % 60; | |
if (minutes < 10) { | |
minutes = '0' + minutes; | |
} | |
if (hours < 10) { | |
hours = '0' + hours; | |
} | |
return hours + ':' + minutes; | |
}, | |
}, | |
}, | |
x: { | |
ticks: { | |
maxRotation: 90, | |
minRotation: 90, | |
}, | |
}, | |
}, | |
}, | |
}; | |
input.func(chartData, dv.container); |
This startDate is not the first entry of the graph. You have to filter your input for a specific date range to achive this I think.
You can try something like this:
https://gist.github.com/YukiGasai/82829809daa0b488fd16bc7e9c82b6c2#file-view-js-L1-L5
view.js
let pages = dv
.pages('#DailyNote')
.filter(p => p.date.day != undefined)
.filter(p => p.sleepStart != undefined)
.filter(p => window.moment(p.date.day).isAfter(window.moment(input.start) && window.moment(p.date.day).isBefore(window.moment(input.end))
.sort(p => p.date)
you have to add start and end to the args in the dataview block
Thank you. Can you show me how to pass the args in the dataview block?
const settings = {
func: window.renderChart,
range: 7,
start: "2023-11-01", <--
end: "2023-11-03", <--
}
await dv.view("Atlas/Utilities/Templates", settings);
Hi bro thanks for all your help. Now the code compiles well but the graph is not showing. The reason I think is because this filter: .filter(p => window.moment(p.date.day).isAfter(window.moment(input.start.day)) never return data to the pages variable. If I not put it the data come well. I debug my dates in console and I dont see an error. Ex 2023-10-25.isAfter(2023-10-20) as start date but I dont recieve data after the filter. I hope you can give me an idea of what is happening
What is the difference between rating and sleeprating?
Does your weekly note have the same date format as the daily note?
startDate = moment('2022-06-15T' + value[0]); } else { startDate = moment('2022-06-16T' + value[0]); Do you use templater here?
Preview
Insertion
```dataviewjs const settings = { func: window.renderChart, range: 7 } await dv.view("Utils/Views/SleepTracker", settings);
The code is not using templater at all it only requires dataview and the chart.js plugin to render the graph.
What is the difference between rating and sleeprating?
Rating is how good the day was sleep rating how well I slept
Does your weekly note have the same date format as the daily note?
I don't have a weekly note
Thanks for helping me =)
Got it! 🙂
const configsono = {
func: window.renderChart,
startDate: <% moment(tp.file.title,"[S]ww-gggg").day(0).format("DD-MM-YYYY") %>
endDate: <% moment(tp.file.title,"[S]ww-gggg").add(1,'weeks').day(0).format("DD-MM-YYYY") %>
}
await dv.view("Dispensa/Views/SonoUnificado", configSono)
Script
https://github.com/lucasbcgeo/sonorepository/blob/main/SonoUnificado
I already managed to render and it worked as planned. Thank you.
I want to do a little change in the script. I hope you can help me out.
I want to enter the start date manually, to decide the date range of the plot.
In this line --> let startDate = moment(); I want to be able to pass the date in my note so the script can take it as a parameter and render based on the start date I enter.