Page History
The sunburst chart is a multi-dimensional chart that enables you to visualize hierarchical data. The data is organized and displayed in a series of correlated rings where the innermost ring represents the top hierarchy. The outer rings are arranged and colored to indicate their hierarchical relationship with the inner rings.
| Info |
|---|
Download and connect to the sample data source. We are making this chart using 2 dimensions and 1 measure. |
...
- Connect to the sample data source in Aqua Data Studio.
- From the Dimensions pane, select Order Date and Product Category.
- From the Measures pane, select Profit.
- Click the
tabthe
tab, and then click click
. Visualization builds a Sunburst Chart.
In the sample data source, you will notice that Visualization has moved the Product Category Dimension to the Color Deck, moved Profit Measure to Rows Deck and , and Order Date Dimension to the Label Deck. Also, the Product Category Dimension is moved to the Label Deck. The order of hierarchy formed in Sunburst is based on the placement of dimensions in the Label Deck. You can rearrange the fields in the Label Deck, to change the order of grouping in the chart. In the above example, Product Category forms the inner circle, followed by Order Date that forms the outer circle. Moreover, Visualization places the first dimension to the Color Deck for better display. When you change the default grouping, the chart visualization changes accordingly.
In the sample data source, we have changed the YEAR(OrderDate) to QUARTER(OrderDate) and moved it to the Color Deck so that you can analyze profits of each quarter based on the order date of the product categories.
Show Percentage
...
- In the Chart Properties area, click the Label Deck.
- Select the Show percentage check box. The profit values appear on the chart as a percentage.
Configure a Center Hole
...
- In the Chart Properties Deck, click the Options Deck.
- Move the slider to the right, to configure a hole and the desired width of the hole.
If you click Reset Center Hole Size, Visual Analytics reverts the chart to its original appearance.
Set Axes Style
...
- From the Dimensions pane, select Customer Name.
- From the Measures pane, select Profit and Sales Order ID.
- Click the Visualization tab, and then click
. Visualization builds a Pie Chart.
Choose one of the following axes type.
This is the default style. Visual Analytics merges multiple measures in a single ring.
In this example, Visual Analytics merges both Profit and Sales Order ID profits in a single ring. The customer name (Aaron King) appear twice; one contains profit (0.16%) and the other contains profit by sales 22.69%).
Visual Analytics merges multiple measures in multiple rings. The number of rings depends on the number of measures selected.
In this example, Visual Analytics merges both Profit and Sales Order ID profits in multiple rings; profits are in the inner ring and profit by sales appear in the outer ring.
Show Empty Categories
If your dataset contains null values, Visualization does not display these values while plotting the Sunburst chart. Instead, it displays white space. On enabling Show Empty Categories, Visual Analytics plots null values on the chart. To show empty categories, we have used Currency Code Dimension in place of Product Category.
To display null values
- In the Chart Properties Deck, click Options. By default, Show Empty Categories is turned off.
- In the Show Empty Categories area, click On.
Plot a Symbol Map
...
Visual Analytics plots sunburst charts for each state based on profit. We have filtered records to concentrate only on the US region. For more information on Symbol Map, see How to Make a Symbol Map.
Change Sunburst Size
...
- In the Chart Properties Deck, click the Size Deck.
- Move the slider to the right, to increase the size of the sunburst or to the left to decrease the size of the sunburst.
If you click Reset Pie Size, Visual Analytics reverts the chart to its original appearance.
Other Actions
Other actions that you can perform on a plotted sunburst chart are as follows:
...