br_data = {
let tmp =
aq
.from(data)
.select("titulo", "fecha")
.groupby("titulo", "fecha")
.derive({ year: (d) => d.split(d.fecha, " ")[3] })
.select("titulo", "year")
.groupby("titulo", "year")
.count()
.orderby("year")
.relocate("titulo", { after: "year" })
.rename({ year: "date" })
.rename({ titulo: "name" })
.rename({ count: "value" })
.objects();
return tmp.map((d) => ({
date: new Date(d.date + "-01-01"),
name: d.name,
category: d.name.substr(0, 3),
value: d.value
}));
}