books

stats

Formulas

• % of book read

let(
total,
prop("Books").length(),
prop("Books").filter(current.prop("Status") == "Read").length() / total
)

• % by genre

lets(
total,
prop("Books").length(),
genres,
prop("Books").map(current.prop("Genre")).flat().unique(),
genres.map(
	let(
		genre,
		current,
		join([genre,( prop("Books").filter(contains(current.prop("Genre"), genre)).length() / total)*100+"%"], ": ")
	)
).join("\n")
)

• % by type

lets(
total,
prop("Books").length(),
type,
prop("Books").map(current.prop("Type")).flat().unique(),
type.map(
	let(
		type,
		current,
		join([type,( prop("Books").filter(current.prop("Type") == type).length() / total)*100+"%"], ": ")
	)
).join("\n")
)

Made by lth_29