Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    Displaying the total number of rows at the top of an Analytics report

    • Product: Alma

    Question

    How can an Analytics report be configured to show the total number of rows at the top of the report? This can be used to display a total count of MMS IDs or items returned by a query.

    Answer

    1. On the Criteria tab, add any column to the report (the field does not matter)
    2. Click "Edit formula"
    3. Replace the column formula with MAX(RCOUNT(1))
    4. Optional: check the box for "Custom Headings" and rename the column heading as desired, such as "Column for Counting"
    5. Click "OK"
    6. Click "Column Properties"
    7. On the Column Format tab, check the box in the top right corner labeled "Hide"
    8. Click "OK"
    9. Note the position of the column you just created, counting from the left
    10. Go to the Results tab
    11. In the "Views" menu in the bottom left corner, click "New View" New View Icon in Analytics > "Other Views" > "Narrative"
    12. In the "Narrative" field, enter total @x where x refers to the column position identified in step 9. Example: total @3 if the custom column is the third column in the report
    13. In the "Rows to display" field, enter 1
    14. Click "Done"
    15. Click and drag the "Narrative" view to place it in the desired location in the report

    • Article last edited: 11-Nov-2019
    • Was this article helpful?
    //Feedback