Panel Inspect View

From FojiSoft Docs

The panel inspect view, which you can open via the panel menu, helps you understand and troubleshoot your panels. You can inspect the raw data for any FojiSoft panel, export that data to a comma-separated values (CSV) file, view query requests, and export panel and data JSON.

Note: Not all panel types include all tabs. For example, dashboard list panels do not have raw data to inspect, so they do not display the Stats, Data, or Query tabs.

The panel inspector consists of the following options:

  • The panel inspector displays Inspect: at the top of the pane. Click the arrow in the upper right corner to expand or reduce the pane.
  • Data tab - Shows the raw data returned by the query with transformations applied. Field options such as overrides and value mappings are not applied by default.
  • Stats tab - Shows how long your query takes and how much it returns.
  • JSON tab - Allows you to view and copy the panel JSON, panel data JSON, and data frame structure JSON. This is useful if you are provisioning or administering FojiSoft.
  • Query tab - Shows you the requests to the server sent when Grafana queries the data source.
  • Error tab - Shows the error. Only visible when query returns error.

Download raw query results

FojiSoft generates a CSV file that contains your data, including any transformations to that data. You can choose to view the data before or after the panel applies field options or field option overrides.

  1. Edit the panel that contains the query data you want to download.
  2. In the query editor, click Query Inspector.
  3. Click Data.
  4. If your panel contains multiple queries or queries multiple nodes, then you have additional options.
  5. Select result: Choose which result set data you want to view.
    • Transform data
    • Join by time: View raw data from all your queries at once, one result set per column. Click a column heading to reorder the data.
  6. To see data before the system applies field overrides, click the Formatted data toggle.
  7. To download a CSV file specifically formatted for Excel, click the Download for Excel toggle .
  8. Click Download CSV.

Inspect query performance

The Stats tab displays statistics that tell you how long your query takes, how many queries you send, and the number of rows returned. This information can help you troubleshoot your queries, especially if any of the numbers are unexpectedly high or low.

  1. Edit the panel that contains the query with performance you want to inspect.
  2. In the query editor, click Query Inspector.
  3. Click Stats.

Statistics are displayed in read-only format.

Inspect query request and response data

Inspect query request and response data when you want to troubleshoot a query that returns unexpected results, or fails to return expected results.

  1. Edit the panel that contains the query you want to export.
  2. In the query editor, click Query Inspector.
  3. Click Refresh.
  4. The panel populates with response data.
  5. Make adjustments, as necessary and re-run the query.
  6. To download the query request and response data, click the Copy to clipboard icon and paste the results into another application.