Configuring Dynamic Table Settings

  1. Click Next.

    The Step 3: Specify Design screen appears.

  2. Type a name for the table in the Name field.
  3. Drag items from the Drag Available Fields list to the following areas:
    • Data Field: Specifies the total count for data appearing in the table

    • Row Fields: Specifies how the data is separated horizontally in the table

    • Column Field: Specifies how the data is separated vertically in the table

    Example: Olivia selects the Data View "Detailed Virus/Malware Information". She does not specify any filtering criteria. She wants a table that displays infected clients, the viruses infecting the clients, and the action taken against the viruses by the managed product. Olivia drags the following fields to the Data, Row, and Column Fields:

    • Data Field: Detections

    • Row Fields: Virus/Malware and Action

    • Column Field: Host

  4. Specify the Data Properties for the Data Field:
    1. Type a name for the Data field title.
    2. Specify how the data displays for the Data Field from the Aggregated by list:
      • Total number of instances: Specifies that the total count for the number of incidents is used for the results

      • Number of unique instances: Specifies that only the count for distinct items is used for the results

      • Sum of value: Specifies that the sum of all the values in the "Count" of a Data View column is used for the results

      Example: OfficeScan detects 10 virus instances of the same virus on one computer. The Count number of row would display 10, while Count distinct row displays 1.

  5. Specify the Row Properties for the Row Fields.
    1. Type a name for the Row header title.
    2. Specify how to sort the data in the table from the Sorting list:
      • Aggregation value: Sorts the data according to the data values.

      • Header title: Sorts the data according to the alphabetic order of the header names.

      • Ascending: Sorts the data in ascending order.

      • Descending: Sorts the data in descending order.

    3. Specify how many items display in the Row Fields by selecting Filter summarized result and specifying a value in the Display top text box.

      The default value is 10.

    4. Select Aggregate remaining items to put all remaining items into the group "Other" on the graph.
  6. Specify the Column Properties for the Column Field.
    1. Type a name for the Column header title.
    2. Specify how to sort the data in the table from the Sorting list:
      • Aggregation value: Sorts the data according to the data values.

      • Header title: Sorts the data according to the alphabetic order of the header names.

      • Ascending: Sorts the data in ascending order.

      • Descending: Sorts the data in descending order.

    3. Specify how many columns display by selecting Filter column and specifying a value in the Display top text box.

      The default value is 10.

    4. Select Aggregate remaining items to put all remaining items into the group "Other" on the graph.
  7. Click Save.

    The Add Report Template screen appears.