The Table panel displays metric data in tabular form. In this view, you can review metric values and their associated labels in a single view. Use Table panels for such quantitative analysis where you can see actual values instead of visual representations. Similar to a spreadsheet, you can look at a combination of metric values and their segments. This is useful when you don’t necessarily care about the change in metric over time, or want to run reports to download as CSV/JSON for offline analysis.
The panel displays the value returned by the metric query specified in the Query tab. The value is determined by the data source and the query. Each datapoint will have an associated raw and an option to add columns for additional metric values.
Major features include but not limited to :
The first query you build cannot be removed.
With subsequent queries are built, you cannot remove all the queries except the first one.
Changing the unit of the query changes the unit in the table as well.
Changing the display format on the query reflects on the row values.
The segmentation label determines the column name.
The segmentation in conjunction with metric values determines the values displayed on the rows.
- The selected scope determines the values displayed on the table.
Metric / Labels Columns
Adding a new query insert a new column with the name of the metric as the column heading.
Metric values in conjunction with segmentation determine the values displayed on the rows.
Column sorting is based on the selected column header and the type of sorting (ascending and descending).
When another column is sorted, the table is resorted by that column, resetting the previous sorting.
Grab the header column by the borderline to resize the columns.
Browser window resizes shouldn’t reset the resize of the columns if you have resized any columns.
When resizing the browser window, table columns are resized to cover the full width. An exception is when you have already resized columns. In such cases, other columns that you have not resized are resized on browser window resize.
The last column in the table is not resizable.
The table by default shows a maximum of 50 rows.
Clicking on Export all results… below the table opens the Export Data window.
Export data in either JSON or CVS format to a file. The default name of the file is the panel name. Renaming the default filename is permissible.
For information on configuring a chart, see Create a New Panel.