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

Bentonville, AR 72712

 

479.418.5710 (direct)

479.418.5700 (main)

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  

T: 323.857.4758
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.