How can I display the current location of an item in Analytics?
Answer
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.
Note that we have saved columns in the Los Rios Subject Area Contents folder for both current location name and current location code that you can add to your reports rather than creating your own.