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.
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.