Philosophy Checkouts, vs. Month & Topic
MAT 259, 2015
What time of the year do you feel the need of philosophy?
When end of the year comes? When new year starts?
Or when the leaves start to fall?
And for that, especially what topic of philosophy?
floor(deweyClass) as dewey,
month(checkOut) as month,
sum(timestampdiff(day, date(checkOut), date(checkIn))) as totaltime,
sum(1) as totalnum
_rawXmlDataCheckIns.deweyClass >= 100 and
_rawXmlDataCheckIns.deweyClass < 200
and (checkOut is not null and checkIn is not null
and timestampdiff(day, date(checkOut), date(checkIn)) >= 1
and timestampdiff(day, date(checkOut), date(checkIn)) <= 100)
and (year(checkOut) >= 2013 and year(checkOut) < 2014)
This visualization will show number of times loaned on z axis, w.r.t. the specific subject within category of philosophy and month in year. Also, longer the items loaned they will be more red-tinted.
Interesting fact found is that while there's no significant change throughout the year, loan rate throughout the topics vary very much. For example, while induction & deduction related books were not loaned almost at all, books related to conscious&subconscious topics were very often loaned.