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.
