[Wactclc-alma] Analytics R & D for a Friday afternoon - AVG and MEDIAN publication date by LC / Dewey Classification

[Guidry, Wade]

BBCC has been after an analytics report to show average publication date by call number classification.

Between John, Shellie and myself, we've come up with a few reports that get at that information.

There are currently 4 reports in Shared Folders / Community / Consortia / WACTCLC related to this goal.

2 of the reports (one each for LC and Dewey) use "End Publication Date"

2 of the reports (again, one each for LC and Dewey) use "Publication Date"

All reports calculate both an AVG and a MEDIAN publication date for each call number category.

Because the MARC data in both "End Publication Date" and "Publication Date" are inconsistently cataloged, and often include text, the formulas for those columns attempt to do some cleanup on the data, in addition to calculating the AVGs and MEDIANs. Because of the cleanup done by the formulas, not all titles will be included in the calculation.

The formulas are a bit too complex to try to explain in an email. But if you open the reports in your environment, you'll see the results for your collection.

The reports aren't going to be 100% accurate, simply due to the limitations of the MARC data. But the results should provide some information.


[cid:image001.png at 01D375B7.3AA170C0]


[Title: Big Bend Community College Logo]

Wade Guidry
Library Consortium Services Manager
Big Bend Community College
wadeg at bigbend.edu<mailto:wadeg at bigbend.edu>

509.760.4474
www.bigbend.edu<http://www.bigbend.edu>

Big Bend Community College * 7662 Chanute Street NE * Moses Lake, WA 98837-3299



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20171215/00290a13/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 163025 bytes
Desc: image001.png
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20171215/00290a13/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 12948 bytes
Desc: image002.png
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20171215/00290a13/attachment-0001.png>