Working with Charts and tables

This section, covers the following key areas:

Viewing Charts

Charts display data graphically. Certain graphing behaviors that they possess result in data being interpreted rather than recorded. Start or end behavior, data granularity, treatment of data holes, line thickness, minimum/maximum versus average, and data envelopes all influence how data is interpreted and displayed in a chart. Hover the mouse over a chart to see data specific to that chart such as the legend and cartesian co-ordinates.

Viewing Tables

You can show or hide any column, search for the required text, and sort any column in a table.

Show hidden columns

Many tables have additional information in hidden columns. You can show or hide any column of the table using the icon to the right of the search bar. This opens the Metric Selector dialog. From this dialog you can view all available columns of data. Click the icon to the left of the column header to select (show) or unselect (hide) the column.

Use the search bar to search all the rows and columns of a table for given text.

Sort

For some tables an up or down arrow to the right of the column header indicates the column the table is sorted on and whether the sort is ascending or descending. Click on the arrow to change the sort order. To sort on a different column, click on that column’s header.

Customizer

Depending on how the chart was designed, the customizer icon might appear when you hover the cursor over a chart or might always be visible. For example, on the Alarms dashboard, the customizer for the Alarm(s) table is always visible. If the customizer icon is enabled you can:

  • Select which columns you want to appear in a table.
  • Change the chart type dynamically.
  • Export charts and tables to PDF, CSV, Excel, XML, or Image format. For more information, refer to Exporting Data from Charts and Tables.

Exporting Data from Charts and Tables

The option to export data to PDF, Excel, CSV, XML, and Image formats are available for charts and tables. For example, you can create new graphs using drag and drop metrics onto a dashboard, and then export the data to CSV output. Therefore, you can create multiple metrics, set a time range, export to CSV, and then open the data in Excel.

To export charts and tables:

  1. Navigate to the chart or table you want to export.
  2. Click the Customizer icon in the top right-hand corner of the table or chart.
  3. Click Export.
  4. Select the format to export.
  5. Select a format and click Next.

The chart is exported in the required format.