Results

The Results area displays query results. It can display query results in a grid or as one of the number of supported chart types.

ExpandedToggleIcon        Results Header

Results header contains the following buttons:

Export buttons

These buttons allows you to export the result data to a file.

CSV

This button is available when viewing data in the grid. It exports all the query results to a CSV file, even if only a part of rows is loaded to the grid.

PDF

This button is available when viewing data as a chart. It exports the current chart to a PDF file.

PNG

This button is available when viewing data as a chart. It exports the current chart to a PNG file.

Table/Chart Buttons

Table View

Displays the query results in a grid.

Line Chart

Displays the query results as a line chart.

Area Chart

Displays the query results as an area chart.

Column Chart

Displays the query results as a column chart.

Bar Chart

Displays the query results as a bar chart.

Pie Chart

Displays the query results as a pie chart.

 

ExpandedToggleIcon        Table View

Table view displays data in a grid. Skyvia Query loads data in portions of 20 rows. If a query returns more rows, than are currently displayed, there is the Load More link when you scroll down the grid to the end, which allows you to load the next portion of rows. You can also press F8 in order to load more rows.

 

ExpandedToggleIconChart View

Table view displays data as charts. Chart view consists of two panes - the chart pane on the left and the chart settings pane on the right.

Chart Pane

The chart pane displays the chart itself and the list of the chart series below it. You can show/hide series on the chart by clicking them in this list.

A pie chart can display only one series at a time. When a pie chart is displayed, the list below the chart lists all the category values. You can point at a category in the list in order to highlight it on the chart, and you can show/hide categories on the chart by clicking them in this list.

If the list does not fit in the page, it is split to several pages.

Chart Settings Pane

The chart settings pane allows you to configure the displayed chart. You can show or hide the chart settings pane by clicking the  button.

Category

Select the category column in this list.

Series

Select the value columns for the series in these lists. Del buttons delete respective series, Add series button adds a series to the chart.

Break by

Allows you to split each of the chart series into several series by values of the selected column. Select a column to split data to the series by in this list.