We have a similar system for our PC galleries. ​Math aside, I've had
difficulty getting CR to analyse location history of an object beyond the
two most recent moves (LACMA is in the middle of an extensive inventory and
CMs have asked for a report that counts resolved LRNs). If it's possible to
this, then I would guess that a combination of datediff formulas and sum
formulas/running totals would work.

If you figure it out I'd love to know!


-A

On Tue, Apr 17, 2018 at 8:03 AM, Jeremy Munro <
[log in to unmask]> wrote:

> Hi all,
>
>
>
> In the interest of the eternal holy grail style quest to create an
> automated way to report out on display times for objects en masse I was
> wondering if anyone has approached it from a location change perspective?
> At CB we only make exhibition records for named shows, though we are
> starting to have interns work through a backlog of historical exhibitions.
> Either way we want to avoid the manual data entry mandated by calculating
> display times from exhibition records.
>
>
>
> We do however have a rigorous and highly accurate set of location moves.
> I’m interested in using CR or a Dataview to run math on the move date of
> sets of moves based on the Purpose (Exhibition or Loan) which is followed
> by a move to Storage (Short or Long Term) and then repeat for every
> instance, culminating in a total amount of display time.
>
>
>
> Is this nuts to try to attempt to do in CR? I know date math can get janky
> at the best of times.
>
>
>
> *Jeremy Munro*
>
> Collections Information Coordinator
>
>
>
> Crystal Bridges Museum of American Art
>
> 600 Museum Way
> <https://maps.google.com/?q=600+Museum+Way+%0D%0A+Bentonville,+AR+72712&entry=gmail&source=g>
>
> Bentonville, AR 72712
> <https://maps.google.com/?q=600+Museum+Way+%0D%0A+Bentonville,+AR+72712&entry=gmail&source=g>
>
>
>
> 479.418.5710 (direct)
>
> 479.418.5700 (main)
>
> CrystalBridges.org <http://crystalbridges.org/>
>
>
> To unsubscribe, send an email to [log in to unmask] with the
> following commands in the body of the email:
>
> signoff TMSUSERS
>
> // eoj
>
> You will receive a confirmation that your subscription has been removed.
>



-- 

*AMANDA DEAROLPH*

DATABASE ADMINISTRATOR
COLLECTION INFORMATION & DIGITAL ASSETS
WWW.LACMA.ORG

T: 323.857.4758
E: [log in to unmask]

To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:

     signoff TMSUSERS

     //  eoj


You will receive a confirmation that your subscription has been removed.