Configuring Line and Timeline Charts in the Report Builder

When you add a line or timeline chart to a report, you can configure additional options.

Before You Begin

  • Build a Report

  • To build and deploy reports, your CommCell user account requires a role with the Add Report permission and an association with the CommCell entity.

For more information on users, permissions, and associations, see User Administration and Security - Overview.

Procedure

  1. On the Web Console for the Private Metrics Reporting Server, click Reports.

    The Worldwide Dashboard appears.

  2. To open a report where you have already added a data set, from the navigation pane, click Configuration > Reports, and next to the Report Name under Actions, click Edit.

  3. Optional: If your report has multiple pages, click the tab for the page that you want to edit.

  4. Drag Line Chart or Timeline Chart to the Drop components to build the report box.

  5. From the Data Sets list, drag a field name to the Drop X-Axis box.

    Timeline charts support only time stamp, date, and integer field types for the first field in the Drop X-Axis box. While integer field types are allowed, they are assumed to be UNIX timestamps in Coordinated Universal Time (UTC).

    You can add alphabetic-type fields to the Drop X-Axis box as a secondary piece of information.

    line_drop_x_axis

  6. Configure the Drop Y-Axis box for line or timeline charts:

    • For line charts, if you want to graph something other than default, delete the Y-Axis selection, and from the Data Sets list, drag another field name to the Drop Y-Axis box.

    • For timeline charts, from the Data Sets list, drag a field name to the Drop Y-Axis box.

  7. Select an option for the type of aggregate information that you want to display for each field name in the chart.

    Options vary based on the type of field that you select.

    line_field_option

  8. You can drop multiple field names into the Drop X-Axis and Drop Y-Axis box to plot additional information in the chart.

    line_drop_y_axis

  9. Select the chart, on the Properties tab, click Generalproperties_general, and configure any of the settings.

    The following table lists the properties you can change:

    Goal

    Perform action under General

    Enter a label for the chart

    In the Chart Title box, type a name for the chart.

    Customize the label for the Y-Axis

    In the Y-Axis Title box, type a name.

    Customize the label for the X-Axis

    In the X-Axis Title box, type a name.

    Change the type of chart displayed

    In the Chart Type list, selection another type of chart such as Horizontal Bar or Pie Chart. Available only for Line charts.

    Show the gridlines

    Select Show Gridlines.

    For Line Charts, display curved lines instead of straight lines

    Select Smooth Lines.

    Display the value above each data points

    Select Show Labels. If there are too many data points to display, then the labels will be automatically sampled.

    Hide the legend

    Clear Show Legend.

    Configure the placement of the legend in the chart

    In the Legend Position list, select Top, Bottom, Left, or Right.

    Hide the data point markers

    Clear Show Markers.

    Configure the maximum number of characters in legend labels

    In the Max Legend Label Length box, type a number.

    Select who can view the component

    From the Visible list, select any one of the following options:

    • All: To allow everyone see the component, select this option.

    • CommCell Admin: To allow only CommCell administrators see the component, select this option.

    • Tenant Admin: To allow only only tenant administrators see the component, select this option.

    • Custom: To allow users see the report based on the permissions, select this option, then in the Visible Expression box, enter a JavaScript statement.

      For example, to allow MSP users see the component, in the Visible Expression box, enter := return cv.isMspUser.

  10. On the Properties tab, click Fields fields_tab, and configure any of the settings:

    • Configure the chart settings under Sorting.

      The following table lists the properties you can change:

      Goal

      Perform action under Sorting

      Sort x-axis data in ascending order

      In the Sort Order list, select Asc for ascending.

      Sort x-axis data in descending order

      In the Sort Order list, select Desc for ascending.

    • Configure the chart settings under Measure.

      The following table lists the properties you can change:

      Goal

      Perform action under Measure

      Automatically convert display sizes for labels.

      Select Auto convert values.

      For example, 10,000 KB is converted to 10 MB.

      Specify the type of numeric value to display for the lines.

      In the Aggregate list, select one of the available options, such as Distinct or Avg.

    • Configure the chart settings under Dimension.

      Note: These options are not available for Timeline charts.

      The following table lists the properties you can change:

      Goal

      Perform action under Dimension

      Display line labels in a slanted angle.

      Select Slant X-Axis labels, and then in the list, specify the degree of the angle. If there are over five labels, then labels will be automatically slanted.

      Specify a maximum number of data points that will appear in the chart

      Expand the Field Name, and under X-Axis, next to Max Points, type the maximum number of X-Axis types.

      Include all data points in the chart

      Expand the Field Name, and set All Points to On.

    • To configure settings in Formatter under Measure or Dimension, see Formatting Data in Components for Build Your Own Reports.

    • Optional: Configure the chart settings under Custom Colors:

      1. Click Customize Series Colors add_data_source.

        A list box and color box appear.

      2. Select a value from the list, or type a value, if not available in the list, and then click on the box next to it.

      3. In the Color dialog box, select a color, and then click OK.

      4. Repeat these steps to specify a color for any value.

        custom_colors

      5. You can click the Default Color box, select a color from the Color dialog box, and then click OK.

        Any bar that is not configured with a custom color displays the color configured in the Default Color box.

  11. To configure settings under Custom Group, see Configuring Custom Groups in Charts.

  12. To configure settings under Custom Code custom_code_tab, see Configuring Custom Code and Custom Styles for Reports.

  13. To save this version of your report specification in the Reports Manager, at the top of the Report Builder page, click Save.

  14. To make the report available to end users on the Reports page, at the top of the page, click Deploy.

Loading...