Hierarchical Charts

SQL Frames supports a special DataFrame called Hierarchical DataFrame. These hierarchical dataframes can be used to represent different levels of details. For example, revenue can be summarized by year and quarter. As both levels are present, they can be displayed in a single chart that allows viewing at a higher level and then inline drill-down into more granular level.

The levelname API provides the name of the level the data record belongs to in a hierarchical DataFrame. This API is used to color the bars to distinguish the granularity of the bars. Refer to Visual Mapping to learn about coloring the data.

Clicking the bar or expanding the year record in the DataFrame below will update the chart to show data by quarter.

Hierarchical Charts

Time Hierarchy

Geography Hierarchy

Sunburst Chart

Treemap Chart

Hierarchical Charts

Time Hierarchy​

Geography Hierarchy​

Sunburst Chart​

Treemap Chart​

Time Hierarchy

Geography Hierarchy

Sunburst Chart

Treemap Chart