This is build on top of Dataview, how to make table of read book by month and year as sum?
It is working fine in each row is year and in each column is month (1…12) and each cell is number of read books.
TABLE
replace(string(length(filter(rows.end, (e) => e.month = 1))), "0", "\-") as "1",
replace(string(length(filter(rows.end, (e) => e.month = 2))), "0", "\-") as "2",
replace(string(length(filter(rows.end, (e) => e.month = 3))), "0", "\-") as "3",
replace(string(length(filter(rows.end, (e) => e.month = 4))), "0", "\-") as "4",
replace(string(length(filter(rows.end, (e) => e.month = 5))), "0", "\-") as "5",
replace(string(length(filter(rows.end, (e) => e.month = 6))), "0", "\-") as "6",
replace(string(length(filter(rows.end, (e) => e.month = 7))), "0", "\-") as "7",
replace(string(length(filter(rows.end, (e) => e.month = 8))), "0", "\-") as "8",
replace(string(length(filter(rows.end, (e) => e.month = 9))), "0", "\-") as "9",
replace(string(length(filter(rows.end, (e) => e.month = 10))), "0", "\-") as "10",
replace(string(length(filter(rows.end, (e) => e.month = 11))), "0", "\-") as "11",
replace(string(length(filter(rows.end, (e) => e.month = 12))), "0", "\-") as "12",
length(rows.title) as PerYear
FROM "books"
GROUP BY end.year AS Month
What I’m trying to do
Currently I can see how many book are read per year/month, but not which books are read.
So I would like that when I hover on number in cell I get popup of all the book titles for that year/month with link to each.
Then I can have a quick remainder of read books.
Things I have tried
I have no idea is this even possible, so far I have only lookup Functions - Dataview, but have not found solution.