Visualize Results in Charts
- Capella Columnar
- how-to
After you run a query, you can visualize its results in graphical format.
Prerequisites
To use the workbench for Capella Columnar:
-
You must have the
Organization Owner
role in your organization, or one of the following project roles for the project that contains your cluster:-
Database Data Reader/Writer
(Allows queries that read and write data) -
Database Data Reader
(Allows read-only queries)
Configure Graph Settings
When you select the Chart tab in the query results pane, you can visualize query results in graphical format.
You select the type of graph, and then choose the fields—JSON keys—to include. For example, to populate a bar or pie chart:
-
For the first, x-axis selection you choose a field with a string-type value
-
For the second, y-axis selection you choose a number-type value.
For an X-Y graph, on the other hand, both fields must have number-type values.
In this example for the travel-sample’s airport collection, a bar chart plots the results of a query. The x-axis plots the country and the number of airports is on the y-axis.
For more information about working with sample datasets, see Access Data.