Using %-of-Compared breakdown mode for analysis

The %-of-Compared breakdown mode shows each aggregate measurement with relevance (percentage) to the measurement of the compared data group.

The percentage values are shown in the visualizations and measurement labels. The specific visualization results also depend on data selections and  visualization settings, such as group-views, axis scales and extents, and so on. Previously, this mode was called "dependent breakdown".


In the sample chart capture above,

  • Different colors show different property types. The top data status panel, as well as the tooltip for pointed room type (private room) clarifies the colors.
  • The breakdown section in tooltip, and chart visualizations show the Room Type percentages out of each Property Type. For example, 
    • 85% out of the apartment property types are Entire home/apt type.
    • 26.6% out of the condominium property types are Private room type.

Special Features

  • When using %-of-Compared mode without comparison selections, Keshif shows percentages out-of-total for the whole data aggregates.
  • %-based breakdown modes cannot be used with average measure functions, or sum measure function with negative totals. In other words, this mode can be used only when using Count function, or Sum function with positive values, so that the percentages can be validly computed.
  • Stacked charts cannot be used with %-of-Compared mode.