How to download data for an entire controller

Hi Gregory, welcome to the forum and thank you for your question.

Downloading desired data for a desired time is done in the following steps

  1. Build a custom dashboard for visualizing and saving your work.
  2. Gather queries for all desired data
  3. Paste those queries into a single dashboard panel
  4. Export that panel to a CSV file for viewing in Excel or other spreadsheet

1. Building a Custom Dashboard

Instructions for building a custom dashboard are at this link: Writing Custom Dashboards

2. Gathering Desired Queries

Each card has a dashboard containing a graph for every element kept in the time series database.

To identify the prometheus query for any panel, right-click on the panel heading and select Explore

ExplorePanel

The prometheus query can be found under Metrics. You will be pasting these later on, so gather these queries for each panel you wish to export.

3. Paste Queries Into a Single Dashboard Panel

Go to the following screen as outlined in the Custom Dashboards article.

Paste your first query in 1, then select 2 to add each additional query.

Save your changes and return to the dashboard. Your graph should show a line for each of your queries.

4. Export Your Data to a CSV File

Once you’re happy with the queries shown in the graph, export that data by right-clicking on the panel heading and selecting Inspect / Data.

Be sure to select Series joined by time in the Show data frame section, then select Download CSV to export your data.