Sunburst charts are an effective way to display and analyze hierarchical data. Each level of the sunburst chart (hierarchy) is shown as a ring or circle. The innermost circle is the root (or top) of the hierarchy.
Rings are sliced and divided based on their hierarchical relationship. The angle of each slice is either divided equally under its parent node or can be made proportional to a value. Color can be used to highlight hierarchical groupings or specific categories.
Working with sunburst charts
A sunburst chart can be a single circle with no hierarchical data, or a series of concentric circles that represent multiple levels of hierarchical data. The measures that make up a query denote the relationships between the outer and the inner sunburst rings, as well as how the rings are broken into contributing pieces.
This section demonstrates how to create a multi-level sunburst chart. We start by structuring a query that compares two measures, then splits the results into two groups.
To create a multi-level sunburst chart, do the following:
- Open Explorer, select a dataset in the upper left corner of the window, specify variables for measure 1, then enter a unique name for the measure.
In our example, we chose the movies database, and chose to Show count of unique user actors Filtered to user actors with Movies watched in the last 200 days greater than 0, then named the measure Movies watched.
- Click compare to... to display options for measure 2.
- Specify the variables for measure 2 and give it a unique name. They will be compared with the previous measure and shown as a ring in the sunburst chart.
In our example, we chose Show count unique values of Post comment Filtered to all user actors, and named the measure Post comment.
- Specify options to Split by, clicking none and choosing from the drop-down list. Click the plus (+) sign to add another split by option. This groups the data into the selected categories that are displayed as circles in the sunburst chart.
In our example, we chose to split by timestamp and user actors.
- Specify Starting and Ending times. In our example, we entered a Starting time of 200 days ago and an Ending time of now.
- Optional: Click compare to... and specify a time Offset. This shows another set of charts for the offset time.
- Click GO, and then click the Sunburst View icon at the top of the window. We received the following results in our example.