Renewed Report Builder: Column chart

Add a Column Chart widget to your customized report to show respondents' results at a glance. This is a great way of displaying data because it is easy to compare the columns.

---

---

This guide will teach you:

1. Add a column chart
2. Setup the widget
3. Additional settings
4. Additional buttons

1. Add a column chart

To add a column chart to the page, all you have to do is click on it and drag and drop it on the page. 

If you would like to create columns and split your content in more widgets, then first you would need to select the number of columns you want.

You can find all the different column formats at the layout widgets.

Then you can drag and drop the column widget on your page and add the widget in the column. 

Once you add the widget a pop-up window will open where you can add your content.

2. Setup the widget

1.1  Create a single column chart

1.2  Create a multi-column chart

You need three elements to build your graph: Dimension Group label, Dimension Labels, and Metrics.

• Dimension group labels are the names given to the sets of results along the horizontal axis. These could be, for example, different topics of a subject.
• Dimension labels are the description of each category and are shown in the legend underneath the graph. These could be "Employee A" and "Average Score"
• The metrics are the numerical data in each dimension. This would usually be a score, either picked from one of the survey variables, or a set value.

Before we move to the next step, you'll have to decide what type of graph you would like to use. A single column, where you present each respondent's score in a column or you can use a multi-column to compare scores with a benchmark.

1.1 Create a single column chart

If you choose to create a graph similar to this example, you don't need to create any dimension groups. Instead, you can immediately start with the Dimension Labels and Metrics.

1. Dimension Label - give a name to the column. This name will be shown in the key under the graph.
2. Dimension Color - choose the column color by clicking on the color selector. Take care to choose distinctly different colors for each of the columns so the graph will be easy to read.
3. Dimension Metric - choose where the data for the first column of the graph should be taken from. You can either type in a number or click Variables to access the drop-down menu of variables that you can use. Variables take the data entered during the survey and display it in the graph.
4. Add dimension - click to add another column and repeat the steps above. To create the graph in the example, we created four dimensions in total.

1.2 Create a multi-column chart

Start by adding dimension groups, which correspond to each set of columns.  In our example, we created six dimension groups in total, one for each subject.

Click Add group to add the number of dimension groups you need, and label each one.

Next click Add dimension to start creating the axes for your data points. Start your graph by clicking Add dimension.

1. Dimension Label - give a name to the column. This name will be shown in the key under the graph.
2. Dimension Color - choose the column color by clicking on the color selector. Take care to choose distinctly different colors for each of the columns so the graph will be easy to read.
3. Dimension Metric - choose where the data for the first column of the graph should be taken from. You can either type in a number or click Variables to access the drop-down menu of variables that you can use. Variables take the data entered during the survey and display it in the graph. Ideally, you should have as many Dimension Metrics as you have Dimension Groups. In this case, each value stands for a score. The value for Metric 1 matches with Group 1, in this case, Math. In total, we added four metrics, one for each dimension group (which corresponds to a different school subject).
4. Add dimension- click to add a second data value for each dimension group. You can use this to compare respondents' answers to a benchmark.

In the example shown above, the class average was the second data value for each column, and we entered a number rather than a variable. But you can do anything you want!

Now you've set up your graph, you can also configure the y-axis and add the chart title.

• Y-Axis scale interval - choose the interval spacing for gridlines marking the vertical axis. Make sure you have a few to make the graph easy to read.
• Y-Axis max - until which value do you want your y-axis to display? Enter it here.

In our example above, which shows values as percentages, the maximum value is 100, and gridlines are shown at an interval of 20.

Don't forget to click Save and close to save your changes and see your chart!

3. Additional settings

Select the widget and then at the right of the screen click on the gear button. The widget list will be replaced by the additional settings.

Here you can find the following settings:

1. ID
2. Name
3. Rules
4. Margins
5. Background color
6. Chart settings 

1. ID

This is the ID of the widget.

2. Name

You can name your widget in order to identify it easier.

3. Rules

You can add your widget logic rules to ensure that your content will be visible only when the conditions are true. 

When you click the Edit rule button a new pop-up window will appear.

Select from the dropdown menu the option you want, and then fill in all the required fields. Once you add everything you can click the Submit button.

Your content will not be displayed on the page anymore, instead of the content you will be able to see the widget logic rules.

If you would like to edit your content again just click on the rule and the widget will expand. To edit the rule you would have to click on the Edit rule at the settings.

This is the window where you can delete the rule by clicking on the Delete rule button.

4. Margins

Add margins to create space around elements and move them in your page. By default the margins are set to 0, but you can change that anytime and add the margin you prefer.

5. Background color

You can change the background color of this specific widget by clicking the color selector.

Once you click it the background color selector will expand and you will be able to select the color you want or add the color hex.

To save just click Apply color.

6. Chart settings

You can change the default title and label font size if you want. This is very useful if you are placing your chart inside a column, or you adjust its size. In this case you will have a smaller chart but your text will still be readable.

4. Additional buttons

When you click on your widget 4, blue buttons appear to the right.

The Arrow allows you to move between the different layers of the page. For example if you add a widget in a column then you have 3 layers: the page, the column and the widget. The arrow allows you to quickly select a different layer.

The second icon, the four arrow sign, allows you to move your widget up or down to the page.

The third icon, the page, allows you to copy this widget and the forth icon, the bin, to delete it.

What's next?

• Renewed Report Builder-Bar chart: Add a Bar Chart widget to your customized report to show respondents' results or another data set at a glance. This way you will display your data with rectangular bars. It allows you to show data separated into categories with relative numbers.
• Renewed Report Builder-Gauge chart: Add a gauge chart to your personalized PDF report to represent average or actual scores or percentage results for question blocks or formulas. Respondents can see at a glance if they've scored towards the top-end or bottom-end of the scale. It  allows you to display a large data set visually.
• Renewed Report Builder-Spider chart: A spider chart is a great graphic way to compare results from different questions and visualize performance, for example between school subjects or departments of a business. You can include as many axes as you want, but the most visually appealing and clear would be between three and six axes.