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

    Common Summon Analytics Procedures

    This section describes some common procedures.

    Adding Subtotals to a Report

    This section describes how to add a subtotal to your report and the impact of the order of the columns on your subtotals.
    To create an analytics report with a subtotal:
    1. From the Global Header, select New > Analysis and then select Subject Area > Actions.
    2. Create a report with the following columns:
      • Dates > Month (date)
      • Action Type > Action Group
      • Action Type > Action Sub Group
      • Action Type > Action
      • Action Usage > Actions
    3. Click the Results tab to display the report. For example:
      Actions per Month Report - Example
    4. Calculate a subtotal for each subgroup per month.
      1. Click the Edit icon to display the Edit view.
        Edit View
      2. For the column that you want to calculate a subtotal, click the Sigma icon and then click After. For this example, the Action Sub Group column is used.
        After Option
        The subtotals are now shown:
        Subtotals

    Creating a Report That Performs a Mathematical Formula on Two Columns

    In the following example, one column displays the number of times a facet was selected and the second column displays the number of sessions in which the facet was selected. A third column is created that displays the number of times a facet was selected divided by the number of sessions. This gives an average of how many times the facet was selected within a single session.
    To create this analytics report:
    1. From Primo Analytics, select New > Analysis and then select Subject Area > Facets.
    2. Create a report with the following columns:
      • Dates > Month Date
      • Facets Types > Facet Type
      • Facets Usage > Facets Selected
      • Facets Usage > Sessions
      The criteria for the report appears as follows:
      Selected Columns
    3. Click the Results tab. The following is an example of the results:
      Report
    4. Click the Criteria tab and add a new column that is a measurement — for example, the Sessions column (it is okay that it is selected twice).
      Selected Columns
    5. Click the More Options icon of the new column and select Edit Formula. The Column Formula dialog box is displayed:
      Edit Column Formula
    6. Delete the existing formula.
    7. At the bottom of the Column Formula box, select the Columns tab and select Facets Selected.
      Facets Selected Option
    8. Place the cursor at the end of the formula and then select the forward slash
      (/) button.
      Add Division Symbol
    9. Select the Columns tab and select Sessions. The formula should appear as follows:
      Updated Column Formula
    10. Click the More Options icon of the new column and select Column Properties > Column Format.
    11. Select the Custom Heading check box.
    12. Enter a new name for the column in the Column Heading field.
      Custom Headings
    13. Click the More Options icon of the new column and select Column Properties.
    14. Select the Data Format tab and check the Override Default Data option.
    15. Select 2 from the Decimal Places drop-down list and click OK.
      Adjusting Decimal Places
    16. Click the Results tab to display the report:
      Analytics Report

    Displaying Values Above Each Bar in a Bar Graph

    This section describes how to display values on the top of each bar of a Primo Analytics bar graph.
    To display values on the top of each bar in a Primo Analytics bar graph:
    1. In Alma Analytics, select New > Analysis and then select Subject Area > Facet Usage.
    2. Create a report with the following columns, for example:
      • Facet Types > Facet Type
      • Facet Usage > Facets Selected
    3. In the Results pane click the New View icon and then select Graph > Bar > Default (Vertical).
      Default Bar Graph
    4. Click the Edit icon to edit the graph:
      Pencil Icon
    5. Click the Edit Graph Properties icon :
      Edit Graph Properties Icon
    6. On the Titles and Labels tab, click Data Markers:
      Titles and Labels
    7. On the Display Options tab, select Always:
      Display Options
      The values are now displayed on the top of each bar of the bar graph:
      Values on Top of Each Bar

    Merging Two or More Fields in a Report

    You may want to put several fields together and have text between them (such as joining the Action Group, Sub Group, and Action in a single column separated by spaces). This section describes one way of merging fields.
    To merge two or more fields in a Primo Analytics report:
    1. Select New > Analysis.
    2. Select Subject Area > Actions.
    3. Create a report with the following columns —for example:
      • Action Types > Action Group
      • Action Types > Action Sub Group
      • Action Types > Action
      • Action Usage > Actions
      Selected Columns
    4. Click the Results tab and verify that the columns have been merged:
      Compound Layout
    5. In the Criteria tab of each column that you want to merge, click the More Options icon and then select Edit Formula:
      Edit Formula
      The formula of the column is displayed:
      Column Formula
      The formulas are as follows:
      • Action Group – "Primo Action Usage"."Action Types"."Action Group"
      • Action Sub Group – "Primo Action Usage"."Action Types"."Action Sub Group"
      • Action – "Primo Action Usage"."Action Types"."Action"
    6. Click the More Options icon .
    7. Select Edit Formula for the Action Group field.
    8. After the existing formula, add a pipe and then formulas of the field (or fields) that you want to appear. For example:
      "Primo Action Usage"."Action Types"."Action Group" || "Primo Action Usage"."Action Types"."Action Sub Group" || "Primo Action Usage"."Action Types"."Action"
      Column Formula
    9. Delete the non-desired fields (Action Sub Group and Action fields) by clicking the More Options icon next to the field and then selecting Delete. The updated criteria appears as follows:
      Selected Columns
    10. Click the Results tab. The column now contains Action Group, Sub Group, and Action:
      Merged Fields - No Delimiters
    11. To add delimiters between the merged fields, click the More Options icon and then select Edit Formula.
    12. After each double pipe symbol (||), add the following text to include a dash between each field in the merged column results: ' - ' ||.
      Change the following formula:
      "Primo Action Usage"."Action Types"."Action Group" || "Primo Action Usage"."Action Types"."Action Sub Group" || "Primo Action Usage"."Action Types"."Action"
      To the following formula:
      "Primo Action Usage"."Action Types"."Action Group" || ' - ' || "Primo Action Usage"."Action Types"."Action Sub Group" || ' - ' || "Primo Action Usage"."Action Types"."Action"
      Edit Column Formula
    13. Click the Results tab.
      The fields are separated with a space, dash, and space between each part:
      Compound Layout
    14. Rename the merged field:
      1. Click the More Options icon and select Column Properties:
      2. Enter a new name in the Column Heading field.
      3. Select the Custom Headings check box.
        Column Heading
      4. Change the Column Heading field.
    15. Click the Results tab to see the results:
      Compound Layout

    Using the CASE Condition to Change Text in a Report

    You can use the CASE condition to have an alternate text displayed as a value in an analytics report. In this example, the CASE condition is used to make the following changes:
    • The value for the LCC Facet type is changed to Library of Congress.
    • The value for the Journal Facet type is changed to Journal title.
    To use the CASE condition:
    1. Create a report with the following columns from the Facet Usage subject area:
      • Facet Types > Facet Type
      • Facet Usage > Facets Selected
    2. In the Criteria column, click the More Options icon of the Facet Type column and select Edit Formula. The Column Formula dialog box opens:
      Edit Column Formula - Action Group
    3. Delete the existing formula.
    4. Click the Function button in the Column Formula area:
      Function Button
    5. The Insert Function dialog box opens:
      Insert Function Dialog Box
    6. Select the Expressions folder and then Case (Switch):
      Select Expressions Folder
      The formula now displays as follows:
      Column Formula
      The placeholder expressions (expr2, expr3, and expr4) need to be changed as follows:
      • expr2 – Replace expr2 with LCC. The value must be enclosed in single quotes.
      • expr3 – Replace expr3 with Library of Congress. The value must be enclosed in single quotes.
      • expr4 – Should be the Facets Types.”Facet Type” field. This can be done by selecting Facet Types/Facet Type in the Subject Areas pane, highlighting expr4 in the formula, and then clicking the right arrow.
      Edit Column Formula
      The formula should now appear as follows:
      Updated Column Formula
    7. Click the More Options icon of the new column and select Column Properties > Column Format.
    8. Select the Custom Heading option.
    9. Enter a new name for the column in the Column Heading field.
      Column Properties
    10. Click the Results tab to display the report. LCC now displays as Library of Congress.
      LCC Displays in Results
    11. It is possible to add multiple conditions as shown in the following steps:
      Adding Multiple Conditions
      The report should now appear as follows:
      Updated Results

    Conditionally Changing the Text Format in a Report

    You can change the text in an analytics report to be different colors in order to identify different values at a glance. The following report is used as an example that highlights actions that occurred more than 10,000 times.
    Example Reports with Multiple Actions
    To conditionally change the format of a value in a Primo Analytics report:
    1. In the Actions field, click the More Options icon and select Column Properties:
      Column Properties
    2. On the Conditional Format tab, select Add Condition > Actions.
      Conditional Format
    3. For example, configure the following fields and then click OK to add the new condition:
      • Operator – Select is greater than.
      • Value – Select 10000.
    4. Select is greater than from the Operator field and then select 10000 from the Value field.
      Add New Condition
    5. Select the style for the value – for example, change the background color to yellow.
      Change Value’s Background to Yellow
      Actions that are greater than 10,000 now have a yellow background in results.
      Highlighted Values in Results

    Creating a Prompt in a Report

    You can create a Primo Analytics report with prompts that ask you to select the variables with which to create a report. The report in this example is for a report on the number of Search group actions within a date range. You are prompted to enter a date range, which is used to create the report.
    Although there are three kinds of prompts available in Primo Analytics reports (column prompt, variable prompt, and image prompt), this example only demonstrates the column prompt.
    To create the analytics report:
    1. Select New > Analysis.
    2. Select Subject Area > Actions.
    3. Select from the following columns — for example, the Action Group column:
      • Action Types > Action Group
      • Action Types > Action Sub Group
      • Action Types > Action
      • Action Usage > Actions
    4. Click the More Options icon and select Filter.
    5. In the New Filter dialog box, specify the following fields.
      • Operator – Select is equal to / is in.
      • Value – Select Search.
      Add New Filter
      Do not set filters for the columns that you want to have a prompt.
    6. Click the Results tab. For example, the following is displayed:
      Report Results
    7. On the Prompts tab, click the plus sign to add a new prompt.
      Prompts Tab
    8. Select More Columns.
      More Columns Option
    9. Select the Dates > Date field.
      Select the Date Option
    10. In the New Prompt dialog box, specify the following fields for the date and click OK.
      • Operator – Select is between.
      • User Input – Select Calendar.
      New Prompt Dialog Box
    11. Navigate to the report from the Catalog/Dashboard in which it was saved.
    12. Click the Open action (not Edit) to run the report.
      Run Report - Open Action
      The prompts are displayed:
      Date Prompt
    13. Specify the date range and click OK.
    • Was this article helpful?