Combining "Request Type", "Work Order Type" & "Process Type" in a single analytics report
We'd like to retrieve a full list (with breakdown of all Work Order Type, including withdrawn, display, missing, not for circulation items…etc) of physical records by Material Type, Word Order Type & Process Type via Analytics. However, only part of records can be retrieved currently after combining Process Type & Work Order Type together. After consulting Salesforce, it is confirmed Analytics do not support to combine these fields together in a single report. It's crucial to enable combining these fields in a report as library always need to review the figures of each Work Order Type & Process Type, not only Process Type. The two information would help us to review the item status more comprehensively.