100% stacked bars

This example will walk you through how to create a simple 100% stacked bar chart when you have one continuous field that’s broken down by some dimension.

One measure

  1. First, you’ll want to create a normal stacked bar chart. You can follow along step-by-step here.

  2. Now that you have a stacked bar chart, the last step is to normalize each stack in the bar based on the total value of that bar. You can do so by leveraging our Quick Calculations feature. Click on the caret of the continuous field in Rows to expand its field settings. The Quick Calculations options appears in the context menu. From there, you’ll want select the Percent of Total calculation type with the Table Down level and direction.

    Percent of Total
    Calculate using Table down

Multiple measures

  1. First, you’ll want to create a normal stacked bar chart. You can follow along step-by-step here.

  2. Now that you have a stacked bar chart, the last step is to normalize each stack in the bar based on the total value of that bar. You can do so by leveraging our Quick Calculations feature. Click on the caret of the continuous fields in Measure Values to expand the field settings. The Quick Calculations options appears in the context menu. From there, you’ll want select the Percent of Total calculation type with the Table Down level and direction.

    Percent of total
    Table down

Was this page helpful?