Column Reports

Column charts display combinations of groupings and measures as vertical columns. Three different examples are shown below:

You can toggle the 'Cumulative' setting through the Report Editor -> Configuration -> Report Properties -> Formatting. When toggled, the chart will accumulate values across the different bars in the chart as hown below:

You can set a 'Minimum Column Width' setting through the Report Editor -> Configuration -> Report Properties -> Formatting. This value provides a minimum width (in pixels) for the bars in the chart. If the resulting chart is larger than the available screen width, the chart will enable horizontal scrolling. This setting tends to help with display of large data sets and with display on smaller devices such as phones or tablets.

You can toggle the 'Fill In Zero Values' setting through the Report Editor -> Configuration -> Report Properties -> Formatting. When toggled, the chart will include the display of measure values where no data was present as shown below:

If you have multiple measures in your chart, ou can toggle the 'Two Axis' setting through the Report Editor -> Configuration -> Report Properties -> Formatting. When toggled, the chart will move the second measure of the chart into matching up against an axis drawn on the right side of chart:/p>

The following properties are set in the Report Editor -> Configuration -> Report Properties -> Formatting.

• Chart Sort: Specifies the sort direction used in the chart with options of X-Axis Descending, X-Axis Ascending, Y-Axis Descending, and Y-Axis Ascending.
• Label Position: If set to Auto, each column will show its value as a number on top of the column. If set to None, no value will be shown.
• Summary Average: If toggled, any measure with a value of zero will be shown instead as a blank cell.
• Summary Row: If toggled, no summary column will shown for each row as the rightmost column of the crosstab.
• Empty Values to End: If toggled, any column with no value will be moved to the right end of the chart.
• Show Legend: If toggled, a legend will be shown for each measure in the chart.
• Directional Legend: If toggled, you can choose where to place the legend on the chart.
• Legend Placement: Allows you to specify where the legend should be placed on the chart.
• Multi Measure Labels: If the chart has multiple measures, each measure column will have its value shown as a number on top of the column.
• Two Axis Cutoff: If you've specified that the chart should have two axes, this number determines which measures go to which axes. Values start at zero. For example, if you have two measures on the chart and want the second measure to map to the right axis, use a value of one in this field.
• Font Family: If specified, the custom font configured will be used for rendering the list.

The following properties are set in the Report Editor -> Additional Configuration -> Edit Properties -> Color Scheme.

• Color Set: This property determines which color scheme is used in the report. When set to Primary or Secondary, it will use the colors defined in your Account Skin in the Account section of the application. If you set the property to None, you can customize the color scheme for the report.