Exporting aggregated analytics data from a visualization

From a visualization, you can view the raw aggregated data from which the graphical representation is constructed, and then export that data to a CSV file.

Procedure

To export analytics data from a visualization, complete the following steps.

  1. Navigate to the Analytics page and click Visualize.
  2. Select a visualization by clicking it.

    For example, you might select the visualization called Status Codes (Detailed) as shown in the following image:

    Visualization in graph format
  3. Display the data in grid format by clicking the Caret icon that displays after the visualization.
    In the resulting grid, a row is displayed for each aggregated data set that matches the search criteria configured in the visualization's aggregation builder. The raw data shown in the columns and rows depends on the type of visualization accessed and the aggregations configured for that visualization.
    Visualization in grid format
  4. Export a tabular format of the raw data that is displayed in the grid:
    • To export the data as stored in Elasticsearch, click the Raw link.
    • To export Kibana formatted data that is similar to what you see in the grid, click the Formatted link.
  5. When prompted, choose to save the file, which is named visualization_name.csv by default.

    The file is saved to the download location that is configured for your browser. If you intend to export more than once from the same or another visualization, and you are exporting to the same location each time, you might want to rename each file with a meaningful name.