Column visualization
This article applies to the following Customer Insights roles: Developer
Data is displayed as a set of vertical bars, with the height of each bar proportional to the underlying data (the higher number the taller the bar).
In this article:
- Customizing the Visualization
- The Plot Tab
- The Series Tab
- The Values Tab
- The X Tab
- The Y Tab
Customizing the visualization
To customize the column chart visualization (change colors, change the number format, change the axis label, etc.), click Edit to display the parameters menu.
Each of the tabs on this menu, and each configuration option found on these tabs, is detailed in the next few sections of this documentation.
The Plot tab
Configuration options for the visualization.
Series Position
Determines how data is displayed on a chart that has multiple data series. Allowed values are:
-
Grouped. Series are displayed in groups:
-
Stacked. Series are cumulatively plotted on the chart, with the total value (the height of each column) representing the combined value of each series in the group:
-
Stacked Percentage. Series vales are displayed as percentages, with all values adding up to 100%.
Show Percent of Previous
When set to On, adds arrow labels that show the percentage increase from one column to the next. For example:
Inner Spacing
Determines the relative amount of spacing between columns (which effectively sets the width of each column). Values can range from 0 (minimum spacing) to 1 (maximum spacing). For example, here’s a chart with inner spacing set to 0:
And here’s that same chart with inner spacing set to .5:
Spacing
Determines the relative amount of spacing between column groups (which effectively sets the width of each column). Values can range from 0 (minimum spacing) to 1 (maximum spacing). For example, here’s a chart with spacing set to 0:
And here’s the same chart with spacing set to .5:
This feature can only be used with charts that plot more than one dataset.
Hide Legend
When set to On, the chart legend is displayed:
When set to Off, the chart legend is not displayed:
Limit Displayed Rows
When set to On, enables you to chart a specific set of data rows. When you set Limit Displayed Rows to On, you’ll see the following options.
The first list (Hide) specifies whether you want to hide or to show the designated rows. If you choose the hide the rows, all the rows in the table except the selected rows will be displayed. If you choose to show the rows, only the selected rows will be displayed.
To specify the rows, start by using the second list (First) to determine if you want to show or hide the First X number of rows or the Last X number of rows in the table. (You cannot show or hide rows found in middle of the table; for example, you can’t hide rows 25-to-50.) After making your selection then, in the Rows field, enter the number of rows to be displayed or hidden. For example, here we’ve chosen to show the first 8 rows in the table:
If the original visualization looked like this:
The modified visualization looks like this:
The Series tab
Configuration options for individual data series.
Colors
Applies a custom color scheme to the chart. For example, here’s a chart that uses the default color scheme, looker Classic:
And here’s that same chart with the Mixed Neutrals color scheme applied:
Show Full Field Name
When Show Full Field Name is set to On, the entire field name, including the name of the Explore, is shown in the visualization:
When set to Off, only the field name is displayed:
!
Customizations
Used to modify each series displayed in the chart. Allowed values are:
-
Color. To change the color of a column, click the Color box and then, from the dropdown menu, click a new color:
If you have a specific color in mind, you can type the hex value or the CSS color name of that color in the color field:
-
Label. By default, each series in the chart uses the underlying field name as its label:
However, you can change the label for any series by clicking the arrow next to the series name and then typing a new name in the Label field:
That changes the label as shown here:
-
Type. Specifies the type of chart used by the visualization. Valid types are:
- Area
- Column
- Line
- Scatter
For example, suppose you start with a column chart:
If you set the Type to Scatter, the visualization will change accordingly:
Note that, if you have multiple data series in your chart, you can actually mix chart types: one data series could be plotted as a column and another could be plotted as a scatterplot.
The Values tab
Configuration options for displaying individual data points.
Value Labels
When set to On, displays the value of each data point in the chart:
When set to Off value labels are not displayed:
Label Null Columns
When set to On, value labels are displayed for null data points. When set to Off, labels are not displayed for null values:
Value Colors
Specifies a different color for value labels (by default, value labels use the same color as the underlying series). For example:
The label color can be set using an RGB hex value or a CSS color name. For example, this sets the value labels to green:
The chart will then look like this:
Font Size
Specifies the font size for value labels. Typically, this is done by indicating a pixel size; for example, 14px sets the font size to 14 pixels (points):
This sample chart uses the default font size for labels:
And this one uses labels with a font size of 18 pixels (18px):
Value Rotation
Enables you to rotate value labels the specified number of degrees (-360 to 360). For example, this chart has Value Rotation set to 0 (the default value):
This chart has Value Rotation set to 45 degrees:
This option is valid only if the Series Positioning is set to Grouped.
Value Format
Specifies how numeric values are displayed in the visualization. For example, if you want to display your value using a single decimal point, use this format:
#,###.0#
Customer Insights uses Microsoft Excel-style formatting for specifying value formats. For more information, see Guidelines for using decimal places, spaces, colors, and conditions.
Value Density
Slider control that determines the number of value labels displayed in the chart. For example, this chart has the slider set all the way to the right, the maximum density:
The X tab
Configuration options for the X (horizontal) axis.
Scale Type
Determines how the X axis is configured and displayed. Allowed values are:
-
Automatic Based on Data. Customer Insights analyzes the underlying data and sets the X axis scale based on the data types.
-
Ordinal. The X axis is scaled to show evenly-spaced data points, regardless of the relative distance between those points.
-
Time. The X axis is plotted using datetime values. This option is available only if the underlying data is datetime-based.
Reverse Axis
Changes the direction of the X axis. For example, suppose you have a chart that looks like this:
If you set Reverse Axis to On, the chart will “flip,” with the first series becoming the last series, the second series becoming the next-to-last series, etc.:
Show Axis Name
When set to On, the chart displays the name of the X axis:
When set to Off, the chart does not display the name of the X axis:
Custom Axis Name
Specifies a custom name for the X axis:
This name is displayed only if Show Axis Name is set to On.
Axis Value Labels
When set to On, labels for each series are shown on the X axis:
When set to Off series labels are not displayed:
Gridlines
When set to On, vertical gridlines are shown on the chart:
When set to Off, vertical gridlines are not shown:
This option is available only if Axis Value Labels is set to On.
Label Rotation
Enables you to rotate the X axis labels the specified number of degrees (-360 to 360). For example, this chart has Label Rotation set to 0 (the default value):
This chart has Label Rotation set to 45 degrees:
Time Label Format
Specifies how datetime values are displayed on the X axis. For example, to display a date as March 2018 uses this format:
%B %Y
For other datetime formatting options, see Time Formatting for Charts.
This option is available only if the Scale Type is set to Time.
Time Tick Count
Sets the approximate number of tick marks used in the chart; for example, setting Time Tick Count to 10 means the chart displays 10 evenly-spaced tick marks.
This option is available only if the Scale Type is set to Time.
Padding Left
Specifies the amount of whitespace (in pixels) between the left side of the chart and the left side of the X axis. To set the padding, type in any integer value between 0 and 100. For example, this chart has a padding of 0:
And this one has a padding of 100:
Padding Right
Specifies the amount of whitespace (in pixels) between the right side of the chart and the right side of the X axis. To set the padding, type in any integer value between 0 and 100. For example, this chart has a padding of 0:
And this one has a padding of 100:
The Y tab
Configuration options for the Y (vertical) axis.
Gridlines
When set to On, horizontal gridlines are shown on the chart:
When set to Off, horizontal gridlines are not shown:
Reverse Axes
Toggles the position of the Y axis. By default, the Y axis shows 0 at the bottom of the chart and the upper bound of the data at the top of the chart:
When Reverse Axes is set to On, those positions switch: 0 is shown at the top, and the upper bound of the data is shown at the bottom. For example:
Left Axes / Right Axes
Enables you to configure the Y axes for a given chart. By default, charts that have more than one data series put each series on the left axis. In the chart properties, that looks like this:
However, you can drag one or more series from the Left Axes and drop it onto the Right Axes. When you do that, the chart redraws itself to show that series label (and the appropriate set of tick marks) on the right side of the chart:
When you do this, you’ll also see separate configuration tabs for the two axes:
This enables you to configure the two axes in different ways. For example, you can configure a different tick mark density for the right axis:
Scale Type
Specifies how the Y axis is configured and displayed. Allowed values are:
-
Linear. Data is plotted using evenly-spaced intervals:
-
Logarithmic. Data is plotted using a logarithmic scale:
This option is best-used if your data set includes a set of extremely small values as well as a set of extremely large values. With more normalized data, this type of scale can be misleading, making the data points appear closer together than they really are.
Show Axis Name / Axis Name
When set to On, the chart displays the name of the Y axis:
When set to Off, the chart does not display the name of the Y axis:
To set the axis name, type the name in the Axis Name field.
Show Axis Values
When set to On, Y axis values are displayed:
When set to Off, Y axis values are not displayed:
Unpin Axis From Zero
By default, the Y axis starts at 0:
By setting Unpin Axes From Zero to Yes, however, you cause the Y axis to begin at the lowest value in the data rather than at 0.
Y Axis Format
Specifies how numeric values are displayed along the Y axis. For example, if you want to display your value using a single decimal point, use this format:
#,###.0#
Customer Insights uses Microsoft Excel-style formatting for specifying value formats. For more information, see Guidelines for using decimal places, spaces, colors, and conditions.
Tick Density
Sets the number of “tick marks” (reference points) displayed on the axis. Two options are available to you:
- Default
- Custom
When set to Default, you chart might look like this:
When set to Custom, you’ll be given a slider control that lets you add or delete tick marks: sliding the control to the left decreases the number of tick marks, while sliding the control to the right increases the number of tick marks. Suppose you move the slider slightly to the right:
That gives you a chart (and tick marks) that look like this:
Minimum Value
Minimum value displayed on the Y axis. By default, the Y axis starts at 0:
However, by configuring the Minimum Value, you can have at the Y axis start anywhere. For example, here the Y axis start at 250:
Maximum Value
Maximum value displayed on the Y axis. By default, the Y axis displays the largest number in the dataset:
By setting the Maximum Value, however, you can limit the highest displayed number. For example, this graph sets the maximum displayed value to 25000:
Reference Lines
Reference lines emphasize a specific value in your chart. For example, this chart includes a reference line that marks a goal of 250 profiles for each country:
To add a reference line to a chart, click Add Reference Line. In turn, the following options will be available to you:
-
Type. Specifies the type of reference line. Allowed values are:
- Line
- Range
- Line with Margins
-
Value. Specifies the value of the reference line. Options include:
- Median. Line is drawn at the median value in the dataset. The median value is the point that half the values are above and half the values are below.
- Average (mean). Line is drawn at the average value in the dataset.
- Maximum. Line is drawn at the largest value in the dataset.
- Minimum. Line is drawn at the smallest value in the dataset.
- Custom. Specifies the exact value where the reference line will be drawn.
-
Label. Specifies the label for the reference line. If left blank, the reference line uses its value as the label.
-
Label Position. Specifies the position of the label on the reference line. Allowed values are:
- Left
- Center
- Right
-
Color. Specifies a different color for the reference line (the default color is black). To change the line color, click the color icon:
The line color can be set using an RGB hex value or a CSS color name. For example, this sets the reference line to green:
-
Value Format. Specifies how numeric values are displayed in the visualization. For example, if you want to display your value using a single decimal point, use this format:
#,###.0#
Customer Insights uses Microsoft Excel-style formatting for specifying value formats. For more information, see Guidelines for using decimal places, spaces, colors, and conditions.
To delete a reference line, click the Delete button (X) located next to the reference line name:
Trend Line
Trend lines are designed to show trends in your data. For example, are user registrations going up? Are user account deactivations going down? Trend lines help you answer questions like those. In the visualization, a trend line looks similar to this:
To add a trend line to your chart, click Add Trend Line. When you do that, the following options become available to you:
- Trend Type. Specifies the type of trend line to use on the chart. Allowed values are:
- Linear. The trend line is a straight line that fits the data as closely as possible. Linear trend lines are typically used when the data rises or falls at a fairly consistent rate.
- **Exponential. Treats data points on the Y axis as exponential values of data points on the X axis. This type of trend line, which cannot be used if the Y axis contains values equal to or less than 0, is typically used only if Y values rise or fall at very high rates.
- Logarithmic. The trend line plots Y values as logarithmic functions of the X values. This type of trend line, which cannot be used in any of the X values are equal to or less than 0, is typically used only if Y values increase or decrease very quickly and then level out.
- Moving Average. Data is repeatedly plotted as the average of all the previous data points. This type of trend line can often smooth out fluctuations in the data and present a clearer picture of the trend.
If you use the Moving Average trend line you can also specify a custom Period (any integer value). The Period specifies how many data points are included in when calculating the average. For example, to base your trend line on monthly changes, you can set the Period to 30 days (roughly one month).
If the Period is not defined then the moving average is calculated using all the previous data points.
-
Series Index. Specifies which series the trend line is applied to. By default, Customer Insights applies the trend line to first data series in your dataset. The first series has a series index of 1. To apply the trend line to the second data series, set Series Index to 2.
-
Show Label. When set to On, a label is attached to the trend line. When set to Off, only the line itself is displayed:
-
Label Type. Specifies the value of the trend line label.
- String. Specifies a custom label for the trend line; simply type the label in the * Label field. If you leave the Label field blank, the trend line uses set the label to the Trend Type (for example, Moving Avg for a trend line that uses a moving average).
- R^2. Displays the R^2 (coefficient of determination) label of the trend line. The R^2 label effectively tells you well the trend line represents the data. Higher R^2 values are better than lower R^2 values: if the value is 0, the trend line does not match the data at all; if the value is 1 the trend line perfectly matches the data.
- Equation. Displays the equation used to draw the trend line.
-
Label Position. Specifies the position of the label on the trend line. Allowed values are:
- Left. The label is displayed on the left side of the trend line.
- Center. The label is displayed on the right side of the trend line.
- Right. The label is displayed in the middle of the trend line.
-
Color. Specifies a different color for the trend line (the default color is black). To change the line color, click the color icon:
The line color can be set using an RGB hex value or a CSS color name. For example, this sets the reference line to green:
-
Value Format. Specifies how numeric values are displayed in the visualization. For example, if you want to display your value using a single decimal point, use this format:
#,###.0#
Customer Insights uses Microsoft Excel-style formatting for specifying value formats. For more information, see Guidelines for using decimal places, spaces, colors, and conditions.
To delete a trend line, click the Delete button (X) located next to the trend line name:
Updated over 2 years ago