Skip to main content
Adaptive Insights
Knowledge and Support - Adaptive Insights

Data Breakdown

Explains how to use the breakdown setting for Discovery charts.

Breakdown settings present data in categories, such as by time period, sub-accounts, or location. You can specify the breakdown from the Data Settings of a chart. Most chart types have data breakdown options – Gauge, KPI, and Scorecard charts do not.

Breakdown Options Descriptions Chart Type
Dimension Breaks data into categories for in-depth analysis, such as Sales Channel, Location, Product, and many other possibilities. Area, Bar, Column, Doughnut, Line, Pie, Pyramid
None Accounts are not broken into categories. Area, Bar, Column, Line
Metric Breaks data into categories as defined by the account. For example, a waterfall can break data down by Sales metrics: Total Revenue, Cost of Sales, Gross Profit, Admin Costs, and Net Profit.  Waterfall
Series Breaks data by a series as determined by the accounts added to the chart. For example, if you breakdown data by series in a Revenue pie chart, slices are product, service, and maintenance revenue. Doughnut, Funnel, Pie, Pyramid,
Time Granularity, or
Time
Breaks account data into time periods, such as month, quarter, and year. Area, Bar, Column, Doughnut, Line, Pyramid, Waterfall

Second Level Breakdown 

For Area, Bar, Column, and Line charts, you can set a first level and second-level breakdown as way to group and analyze sets of data. For example, you might be interested in reporting on yearly revenue by quarters, but want to breakdown the data further by location or product.

Column Chart Breakdown Examples

Breakdown by Time

The following is an example of a column chart with breakdown by time. Each month in Q1 shows actual revenue for smartphones, mobile services, and maintenance. This chart represents a default configuration for a column chart. 

Example of a Column Chart with a Time Breakdown

The background color displays automatically indicating an actuals overlay.

The following is the same chart with a stacked data series. You can choose to stack or inlay data from the Breakdown section in Data Settings. 

Example Column Chart with a Stacked Data Series

Breakdown by Dimension

The following example shows revenue for smartphone, mobile services, and maintenance with breakdown by the location dimension instead of by time. On the Data Settings, change the breakdown from Time Granularity to Dimension > Location.

DIS-breakdown_columnDimensionaxis.png

The following is example of the same column chart with stacked data series:

Example Column Chart with Breakdown as Location Dimension and Stacked Data Series

No Breakdown

If you want to compare a data series without a time or dimension breakdown, choose None as the Breakdown setting. The following column chart has no breakdown. This chart shows the actuals for 3 revenue streams: Mobile services, Smartphones, and Maintenance Contracts for Q1 (January-March).

Example of a Column Chart with No Breakdown

The following is the same column chart showing data where each data series for Q1 is stacked with a secondary breakdown by location dimension.

Example Column Chart with each Data Series Stacked by Location

Pie Chart Breakdown Examples

You can break pie and doughnut charts by series, time, or dimension.

Breakdown by Series

The following is an example of a pie chart that shows actuals for revenue by data series: Smartphone, Mobile Services, and Maintenance. This chart represents a default configuration for a pie chart. 

Example Pie Chart Showing Revenue by Data Series

Breakdown by Dimension

You can slice a pie or doughnut chart by a dimension.

The following is an example of a pie chart that show revenue actuals by location. Each slice represents the revenue totals for smartphone, mobile servies, and maintenance for the location.

Example Pie Chart with Breakdown by Location Dimension

Breakdown by Time

Sometimes, it make sense to breakdown data in a pie by time. The following example shows two pie charts. Each chart is based on one data series with breakdown of revenue by time. Each slice in each chart represents actual revenue for a year – one slice for each year starting from 2013 through 2016.

Example Pie Charts with Breakdown by Time

Waterfall Breakdown Examples

You can break waterfall data down by metric, dimension, or time.

Breakdown by Metric

The following is an example of a waterfall that  compares planned revenue to actuals for the previous year. The breakdown is by metric, where each step is revenue for three product lines.  This chart represents a default configuration for a waterfall chart.

Example Waterfall that Compared Planned Revenue with Actuals

Breakdown by Dimension

The following waterfall chart shows breakdown of revenue by the location dimension.

Example Waterfall with Breakdown by Location Dimension

Breakdown by Time

The following waterfall chart shows breakdown by time. This chart helps you visualize how revenue was recognized each quarter.

Example of a Waterfall Chart with Breakdown by Time

  • Was this article helpful?