Expandable Table Chart

This article will explain how to create and customize an Expandable Table Chart. So let's get started!

An Expandable table chart is a type of chart that is used to display data in a hierarchical structure, with the ability to expand and collapse individual rows to show or hide additional details.

These charts can be helpful for understanding the distribution of data across different levels of the hierarchy. They can also be used to communicate the data to stakeholders or team members and to allow them to easily explore the details of the data by expanding and collapsing individual rows.

Here is an example of an expandable table chart with some sample data:

This chart shows the population in two different countries at different hierarchies. You can click on the arrow (or accordion) in each row to see the underlying data at the next hierarchical level.

Sample data:

Country	State	County	Population
China	Fujian	Quanzhou	9360
China	Fujian	Fuzhou	7190
China	Fujian	Xiamen	4110
United States	New York	Buffalo	260
United States	New York	New York City	8175
United States	California	Los Angeles	10206
United States	California	San Francisco	884
United States	California	San Diego	3333
United States	New York	Rochester	207

How-to build a line chart?

1. Navigate to Add New Chart screen

2. Select data source

3. Select "Table Chart" type from gallery

4. Configure and customize the chart to create the desired visualization.

Expandable Table chart configuration:

To create a table chart with expandable rows, you need to map your hierarchical data to the dimension(s) and the metric you want to see. In this example, country, state, and county are mapped to the dimension(s), and the population is mapped to the metric. This will allow you to drill down from the country level to the county-level data, as the chart will automatically aggregate the data at each level.

It is important to note that the raw data should be at the least granular level, as shown in the sample data. In this case, each row of data represents the population at the county level, with the hierarchies identified (i.e., the states and countries that these counties belong to).

Expandable Table chart customization options

Infinity offers many customization options for your expandable table chart. To access these options, click on the customize tab in the chart builder screen. This will display a list of customization options.

Here is a list of notable customization options for the line chart.

Feature	Description
Aggregation	To create an aggregation, click on the data series chip in the data mapping section and choose the desired aggregation. There are various aggregation options available based on the data type.
Renaming the Data Series	To rename a data series, click on the data series chip in the data mapping section. A pop-up will appear, allowing you to change the name and any aggregation options.
Table Header	There are several options available for customizing the table header: Modify the font of the header text by changing its color, size, family, and style (bold or italic). Change the background color of the header text. Convert the header text to all uppercase. Make the header fixed so that it does not move when you scroll.
Table Body	Infinity offers the following options for customizing the table body/content: Modify the font of the data in the table by changing its color, size, family, and style (bold or italic). Set the background color for odd and even rows separately. Set the opacity for odd and even rows separately. Adjust the density of the rows to be small, medium, or large. Fix the window or frame for scrolling by indicating the row or column number in the "Fixed Rows" or "Fixed Column" options. You can also change the background color of the fixed cells.
Table Footer	There are several options available for customizing the table footer: Pagination: Enable paginated tables and specify the number of rows per page. Aggregations: Automatically calculate aggregations, such as sum, average, min, max, or others, for each column.
Format Columns	Instructions for customizing a column in a chart: Click on the "Customize" tab. Click on "Series". In the "Series" options, you will find many customization options, including: Customizing the font Adding prefixes Conditional formatting Choose the desired customization options to apply to the column. Repeat the process for additional columns as needed.

Some useful tips for creating table charts with expandable rows include:

1. Start by identifying the data that you want to display.

2. Determine the appropriate hierarchy for the data, based on the level of detail that you want to display.

3. Use clear and concise labels for each level of the hierarchy.

4. Use a clear and consistent formatting style for the table.

5. Make sure that the chart has the ability to expand and collapse individual rows to show or hide additional details.

6. Use the chart to identify areas for improvement or areas where progress is being made towards a goal or target.