Setting graph options in custom reports

You can include a pie graph or a bar graph in custom reports.

You must select at least two fields on the Field Selection dialog box to create a pie graph, and at least three fields to create a bar graph.

To set graph options in custom reports

  1. On the navigation bar, click Reports.

  2. In the tree view, click Custom Reports.

  3. In the reports list, click the report for which you want to set graph options.

  4. In the task pane, click Edit.

  5. On the properties pane, under Report Definition, click Graph Options.

  6. In the Graph type box, select the type of graph that you want to create, either Pie or Bar.

  7. In the Graph title box, type the title that you want to display above the graph in the report.

  8. Complete the following options for a pie graph:

    Category field (pie section per value)

    Select the field for which you want to display sections in the pie chart.

    Data field

    Select the field for which you want to calculate values.

    Aggregation function

    Select the way that you want Backup Exec to calculate the values generated for the Data field.

    Your choices are as follows:

    • Minimum. Calculates the lowest value. This is available for numeric fields only.

    • Maximum. Calculates the highest value. This is available for numeric fields only.

    • Average. Calculates the average value. This is available for numeric fields only.

    • Count. Calculates the number of values. This option is the only available option for non-numeric fields, such as text fields or date fields, but it is also available for numeric fields.

    • Sum. Calculates the sum of the values. This is available for numeric fields only.

  9. Complete the following options for a bar graph:

    Vertical axis title

    Type the title that you want to display to the left of the graph. The title will display vertically in the report. There is a 50-character limit.

    Series field (bar per value)

    Select the field that contains the values that you want to display on the horizontal bars of the graph. Backup Exec creates a legend for the values.

    Category field (set of series bars per value)

    Select the field that contains the information for which you want to group information along the left side of the graph.

    Data field

    Select the field for which you want to calculate values.

    Horizontal axis title

    Type the title that you want to display below the graph.

    Aggregation function

    Select one of the following functions to calculate the values generated for the Data field.

    Your choices are as follows:

    • Minimum. Calculates the lowest value.

    • Maximum. Calculates the highest value.

    • Average. Calculates the average value.

    • Count. Calculates the number of values. This option is available only for non-numeric fields, such as text fields or date fields.

    • Sum. Calculates the sum of the values.

  10. Do any of the following:

    To preview and test the report

    Do the following in the order listed:

    • On the properties pane, under Preview, click Preview.

    • To test the report, on the Preview dialog box, click Test Report.

    To finish and close the report

    Click OK.