[Evergreen-reports] [Sales] Publication year average

[Mike Rylander]

Hi Blake,

The problem is getting the Average transform to be available for a
publication date we pull out of the record already (date1 SVF from 008,
sorting metabib field, pubdate display field, maybe others), but they're
all marked as text instead of numeric.  However, a little adjustment (and
if it works, hopefully followed by a patch) should make it possible.

By default, the Date1 record attribute, which is presented as "Date1" in
the Fixed Field Entry source off the Bib Record source, uses the
"Approximate Low Date Normalize" index normalizer.  That gets the field
into a number-ish state when it contains any data at all, so a change to
the metabib.rec_descriptor view (that's what's under the Fixed Field Entry
source) that casts the date1 column to a number (probably numeric) and
makes sure it's NULL if not number-ish will allow a change to the IDL that
marks that field as an int.  Then, the reporter will let you build
templates that average the field.

Others may have opinions on the ... efficacy ... of forcing the date1 data
into a strict number-ish context, though.

HTH,

--
Mike Rylander
Research and Development Manager
Equinox Open Library Initiative
1-877-OPEN-ILS (673-6457)
miker at equinoxOLI.org
https://equinoxOLI.org


On Fri, Feb 16, 2024 at 11:23 AM Blake Graham-Henderson via
Evergreen-reports <evergreen-reports at list.evergreen-ils.org> wrote:

> Hello all,
>
> We're wrestling with the idea of reporting the average publication year
> for a set of items on certain shelves. As we all know, the publication
> year comes out of the MARC, and includes lots of non-digit characters
> like copyright symbols, brackets, parenthesis, etc. So it would seem we
> can't use that for an average. What is everyone else doing for this? Or
> are you?
>
> --
> -Blake-
> Conducting Magic
> Will consume any data format
> MOBIUS
>
> _______________________________________________
> Evergreen-reports mailing list
> Evergreen-reports at list.evergreen-ils.org
> http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-reports
>
> --
> You received this message because you are subscribed to the Google Groups
> "Sales" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to sales+unsubscribe at equinoxinitiative.org.
> To view this discussion on the web visit
> https://groups.google.com/a/equinoxinitiative.org/d/msgid/sales/6757dbff-10a9-441c-9e13-63d80c643f1b%40mobiusconsortium.org
> .
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://list.evergreen-ils.org/pipermail/evergreen-reports/attachments/20240216/678f70e4/attachment.htm>