The Results area displays query results. It can display query results in a grid or as one of the number of supported chart types.
Results header contains the following buttons:
These buttons allows you to export the result data to a file.
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.
This button is available when viewing data as a chart. It exports the current chart to a PDF file.
This button is available when viewing data as a chart. It exports the current chart to a PNG file.
Displays the query results in a grid.
Displays the query results as a line chart.
Displays the query results as an area chart.
Displays the query results as a column chart.
Displays the query results as a bar chart.
Displays the query results as a pie chart.
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.
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.
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.
Select the category column in this list.
Select the value columns for the series in these lists. Del buttons delete respective series, Add series button adds a series to the chart.
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.