Breakdown: Absolute vs. Relative Breakdown Charts

You can discover new trends in compared data groups by visualizing them using relative or absolute breakdown charts.

  • The absolute-breakdown charts show the absolute size of compared data groups (such as count of records in groups).
  • The relative-breakdown charts show the relative (percentage) frequency of compared data groups within specific data aggregates (such as categories).

You can switch the mode with just a single click, and use stacked or side-by-side charts with both breakdown modes. All aggregate charts in a dashboard use the same breakdown mode. 


How can you set breakdown mode to absolute or relative?

  • Click on the chart axis, or
  • Use the dashboards config panel, via the gear  icon on the upper-left dashboard corner.

Example

Breakdown comparison analysis of four quadrants on a homicides data set.

Analysis of homicides on hispanic race in NW quadrant:

Absolute mode: Among the 96 total cases for hispanic group, 76 were in NW (violet color). The bars for hispanic group are tiny because of the few number of homicides.

Relative mode: 79% (76/96) of the hispanic cases are in NW. The relative quadrant breakdown makes it easier to observe trends by race and quadrant.

Analysis over date by quadrant:

Absolute mode: Time-chart emphasizes the downward trend of homicide cases over time. In 2009, the total number dropped below 150 for the first time since 2000.

Relative mode: Time-chart reveals the relative number of homicides per four quadrants over time (measured annually). In 2009, NW (violet color) had 24% of the incidents, compared to 28% of the incidents in the previous year.


When can you analyze data with relative breakdown?

Keshif helps you prevent misleading data analysis when relative breakdowns would be inaccurate or inappropriate. Specifically,

  • The aggregation function should not be "average".
    Example: You cannot analyze relative "average-age" by gender.
  • The aggregation function should not be "total/sum" with a metric that includes negative values.
    Example: You cannot analyze relative "total-temperature" by season, as temperature may be negative.
  • The dashboard should have at least one compared selection.

When you remove compared selections, the relative breakdown will be auto-disabled.

Still need help? Contact Us Contact Us