How can I display the current location of an item in Analytics?


By default, Alma Analytics can show you the permanent physical location (from the holdings record) or the temporary physical location. But in some reports you just want to know where Alma thinks the item is right now. And in addition, it's important to know whether the value in the item's Temporary Location field is active.

 A custom formula will show the temporary location if it's active and otherwise show the permanent location. To add this column, add a dimension to the report and edit the formula as follows:

CASE WHEN "Physical Item Details" . "Temporary Physical Location In Use" = 'Yes' THEN "Temporary Location" . "Temporary Location Name" ELSE "Location"."Location Name" END

You might want to edit the column name to say "Current Location" or something similar.

Custom formula in Analytics editor



  • Last Updated Aug 11, 2022
  • Views 8
  • Answered By Jeff Karlsen

FAQ Actions

Was this helpful? 0 0