Sum by day

[davidlythgoe]

...with normal apologies for lack of knowledge, amateur coder...

I am trying to aggregate frontmatter entries:

`

studyhours: 2

`

where I might have several entries on the same day.

I have tried:

`

for (let group of dv.pages('""')
.where(p => p.studyhours >0)
.groupBy(p => dv.date(p.file.day))
) 

{

    dv.table(["Name", "Quantity"],
        group.rows
            .map(k => [k.file.day, k["p.studyhours"]]))
}

`

but can't get the group and sum to work...

I nearly get it but can't find the syntax to sum:

Name	Quantity
2022-02-16	1
2022-02-16	1
2022-02-16	1
2022-02-16	1

Name	Quantity
2022-02-17	1
2022-02-17	1
2022-02-17	1

where what I want is:

Name	Quantity
2022-02-16	4
2022-02-17	3

I have tried wiring up:
dv.span(dv.pages().studyhours.array().reduce((a, b) => a + b))

but can't get something that works...

dataview or dataviewjs.

Any ideas?

[davidlythgoe]

fumbled my way to this... which works if it will help anyone else...

let prop = "studyHours"
let colour = "steelblue"

let array = dv.pages().where(p => p[prop]).sort(k => k.file.cday, 'asc').array();

var result = [];

array.reduce(function(res, value) {
  if (!res[value.file.cday]) {
    res[value.file.cday] = { cday: value.file.cday, [prop]: 0 };
    result.push(res[value.file.cday])
  }
  res[value.file.cday][prop] += value[prop];
  return res;
}, {});

let myVals =[]
let myLabels = []

result.forEach
(
p =>
	{
	myLabels.push(
	Intl.DateTimeFormat('en', { day: 'numeric', month: 'short' }).format(p.cday));

	myVals.push(p[prop]);
	}
);


const chartData2 = {
type: 'bar',

data: {
    datasets: [{
	label: prop + " per day",
      data: [...myVals],
	  backgroundColor: colour,             
	  //borderColor: ['cyan'],
     //borderWidth: 3
    }],
	
    labels: [...myLabels]
}
}

window.renderChart(chartData2, this.container);