Configure Report Part Properties for Chart

1. Select the chart in Report Body (See Manage Report Parts for how to add a chart).

2. Click the expand icon (<) on the right to open the Properties boxes if needed.

3. Select the vertical Report Part Properties box.

4. The properties are listed in Report Part Properties box in 7 sections.

   • General Info
   • Chart
   • Labels
   • Legends
   • Grouping
   • Data
   • View
     

User can configure the properties and see changes reflected in Preview pane:

• Select a type in Chart Type drop-down. (See below for each type)

• Configure border settings:

  1. In Chart group, click the gear icon (⚙) to open Border Settings pop-up.

  2. Choose the border to be visible or not.

  3. Select a border color.

  4. Select the border thickness (in pixels).

  5. Click OK to close the Border Settings pop-up.

     

• Set the background color.

  1. In Chart group, click the gear icon (⚙) to open Chart Background Color Settings pop-up.

  2. Select a background color.

  3. Choose to apply the color to the entire chart (the area inside the border above) or to the plot area only (on the right).

  4. Click OK to close the Chart Background Color Settings pop-up.

     

• Configure the X-axis and Y-axis (applicable to the chart types Line, Column, Bar, Area, and Combination only).

  1. Customize the title (“Month” instead of “Group (OrderDate)” and “Freight” instead of “Sum(Freight)”).

  2. Set the title font face and font size.

  3. Choose title text effects bold, italic and underlined.

  4. Choose title text color and background color.

  5. Choose title text alignment.

  6. Customize the starting value for the chart. In the sample screenshot, “3000” is entered into the Starting Point box of Y-axis, so only the points having Sum(Freight) value greater than or equal to 3000 are displayed.

  7. Customize the relative distance between the tick marks. In the sample screenshot, “10000” is entered into the Intervals box of Y-axis, so there will be exactly one tick mark after every 1000 units on Y-axis (4000.00, 5000.00, 6000.00, 7000.00, etc).

     

• Configure the grid lines.

  1. Choose the grid lines to be visible or not.

  2. Select a line color.

  3. Select a line pattern: Solid (default), Dot or Dash.

  4. Select the line thickness (in pixels).

     

• Configure color theme. This option is available from version 2.9.0.

  1. In Chart group, click the gear icon (⚙) next to the Color Theme option to open Color Theme Selection pop-up.

  2. Select a color theme and click OK to the pop-up.

     Note: When the System Admin changes the Default Color Setting, all report parts using the default color theme will change to use the new default theme.
     

     

• Configure multiple colors. This option is available from version 2.9.0.

  1. In Chart group, select Multi-Color check box.

  2. Then the chart will receive one color per point.

     Note:

     - Multi-Color option is only available for single metric charts. When using multiple metrics each metric is a different color.
     - Sparkline chart type does not support Multi-Color option.
     - Multi-Color option is available for Bubble and Scatter from version 2.10.0.
     

  

• Configure the text direction for the labels.

  

• Configure the legends.

  

• Select to use Separator.

  The Separator option displays multiple charts according to each unique value of the field(s) defined in Separators box. For example: this report with multiple pies, each one for each country in Northwind Orders table.

  

  1. Tick Use Separator check-box in Grouping in Report Part Properties to see Separators box inside the chart configuration.

  2. Add [ShipRegion] and [ShipCity] to Labels (X-axis) box, they will show up as Group(ShipRegion) and Group(ShipCity).

  3. Add [OrderID] to Values (Y-axis) box, then choose Count as the Function, it should show up as Count(OrderID).

  4. Add [ShipCountry] to Separators box, it will show up as Group(ShipCountry).

  5. Bottom X% Grouped to Other is used to set the threshold where percentage values lower than that will be grouped together into Others group. See examples below:

     Before: and After setting 60%:

• Choose to display values of data points or not.

  

• Add threshold lines to the chart.

  1. In Data group, click the gear icon (⚙) to open Thresholds Settings pop-up.
  2. In Y-axis, click Add Setting.
  3. Specify the threshold type: Static or Dynamic. Dynamic thresholds option is available from version 2.11.0.
  4. Specify the Field that the threshold belongs to.
  5. Input Label for the threshold. The text format for the static threshold’s label can be customized by clicking the gear icon (⚙)
  6. Input a value for static threshold or add a field then choose a function for
  7. For Static threshold, input a number in Value text box. For Dynamic threshold click “Add a field” then choose a field with its function and specify the format to draw threshold line.
  8. Configure Dashstyle, Color and Thickness.
  9. Remember to tick the Visible text box.
  10. Click OK to close the Thresholds Settings pop-up.
  

• Add regression line (applicable to the chart types Line, Column, Bar, Area, Combination, Scatter, and Bubble only). New in 2.12.0.

  1. In Data group, click the gear icon (⚙) to open Regression Line Settings pop-up.
  2. Select a field to apply the regression line.
  3. Specify whether to display this regression line in the chart plot area or not.
  4. Specify whether to hide this regression line in the chart legend or not.
  5. Input the name for the regression line. If the name is not defined, the equation will display as the regression line’s name. This name is only shown in the tool tip and the legend, it is not displayed in the chart on the line.
  6. Select one of the types from Linear, Polynomial, Logarithmic, or Exponential in Regression Type drop-down.
  7. Input the decimal places for the regression line.
  8. Choose the Order number if the regression line is Polynomial.
  9. Configure the color, dashstyle, and thickness.
  10. Input the extrapolate number if the regression type is Linear or Polynomial.
  11. Click OK to close the Regression Line Settings pop-up.
  
  
  
  

  Zoom into a region of the chart.

  

  1. In View group, select the axis to be magnified:
     • XY: both axis will be magnified.
     • X: X-axis will be magnified while Y-axis remains fixed.
     • Y: Y-axis will be magnified while X-axis remains fixed.
  2. Hold the mouse button and drag over a region, then release the mouse button to actually zoom into that region.
  3. Repeat to zoom closer.
  4. Click the Reset zoom button to restore the chart to normal.
     

• Invert the X-axis and Y-axis by ticking the Inverted check-box in View group.

• Choose a step chart style.

  

• Choose a spline chart style.

  

• Configure how often data is refreshed when report is being viewed.

  

  1. Click the gear icon (⚙) to open Data Refresh Interval Settings pop-up.
  2. Choose to have data refreshed automatically or manually.
  3. Enter an interval between each refresh (in seconds).
  4. Choose to view all data or enter a number to view that specific number of latest records only.
     

Choose Single Y-axis to show all metrics in one Y-axis. This option is only available for combination charts that contain at least two metrics. New in version 2.12.0.
When Single Y-axis is selected, the All axis will be applied and the same format with the first metric’s axis.
The metrics in the combination chart are stacked in the order they are added in the configuration, the first metric added is the on the bottom and the last metric added is on the top. In the example image above, the area chart metric is on top and is the last metric in the chart set up.

Line Chart

A line chart displays data as a series of data points ordered by value and connected by lines. Therefore the line chart is used to visualize a trend in data over intervals of time.

For example, table Orders in Northwind database stores the OrderDate together with the Freight cost of each order. From that data, a report such as the trend of total Freight cost over each month would be best visualized using a line chart.

1. “Each month” means using “Month” format for OrderDate field to get the month numeric value, then using the Group function to group data with the same month numeric value together.
2. Then “total Freight cost over each month” means applying the Sum function for Freight value within each month group.
   

To configure the report like above:

1. Select “Line” as the Chart Type in General Info group, two boxes will appear in Configuration section: “Labels (X-axis)” and “Values (Y-axis)”.
2. Add the field OrderDate into Labels box (drag the field from Middle Panel or use the Add icon +).
3. The field will be given the alias “Group(OrderDate)”.
4. Select the field in Labels box to open the Field Properties box.
5. Check to confirm that in Data Formatting group, “Group” is selected for the Function and “Month” is selected for the Format.
6. Add the field Freight into Values box (drag the field from Middle Panel or use the Add icon +).
7. The field will be given the alias “Sum(Freight)”.
8. Select the field in Values box to open the Field Properties box.
9. Check to confirm that in Data Formatting group, “Sum” is selected for the Function.

Bar Chart and Column Chart

A bar chart displays groups of data as rectangular bars with lengths proportional to the values that they represent. Therefore the bar chart is used to show comparisons among different groups.

The column chart is the same as the bar chart, except for being displayed vertically.

For example, table Suppliers in Northwind database stores the list of suppliers specified by SupplierID together with the Country. From that data, a report such as comparing the number of suppliers per country would be best visualized using a column chart.

1. “Per country” means using the Group function to group data with the same country text value together.
2. Then “the number of suppliers per country” means applying the Count function for SupplierID value within each country group.
   

To configure the report like above:

1. Select “Column” as the Chart Type in General Info group, two boxes will appear in Configuration section: “Labels (X-axis)” and “Values (Y-axis)”.
2. Add the field Country into Labels box (drag the field from Middle Panel or use the Add icon +).
3. The field will be given the alias “Group(Country)”.
4. Select the field in Labels box to open the Field Properties box.
5. Check to confirm that in Data Formatting group, “Group” is selected for the Function.
6. Add the field SupplierID into Values box (drag the field from Middle Panel or use the Add icon +).
7. The field will be given the alias “Count(SupplierID)”.
8. Select the field in Values box to open the Field Properties box.
9. Check to confirm that in Data Formatting group, “Count” is selected for the Function.

Area Chart

An area chart displays graphically quantitative data. It is based on the Line Chart. The area between axis and line are commonly emphasized with colors, textures and hatchings. Commonly one compares with an area chart two or more quantities.

For example, this area chart compares the amount of Product units in stock versus the amount on order.

Another example with Range Only option.

Pie Chart

A pie chart displays data in a circle, divided into slices to illustrate numerical proportion.

For example, a pie chart will compare proportions of the freight cost among different countries.

This pie chart also drills down data to freight cost among different cities in a selected country.

To configure the report like that:

1. Select “Pie” as the Chart Type in General Info group, two boxes will appear in Configuration section: “Labels (X-axis)” and “Values (Y-axis)”.
2. Add the field ShipCountry into Labels box (drag the field from Middle Panel or use the Add icon +).
3. The field will be given the alias “Group(ShipCountry)” (Group function is used as expected).
4. Add the field ShipCity into Labels box (drag the field from Middle Panel or use the Add icon +).
5. The field will be given the alias “Group(ShipCity)” (Group function is used as expected).
6. Add the field Freight into Values box (drag the field from Middle Panel or use the Add icon +).
7. The field will be given the alias “Sum(Freight)” (Sum function is used as expected).

Funnel Chart

A funnel chart displays values as progressively decreasing proportions. Ideally the funnel chart shows a process that starts at 100% and ends with a lower percentage where it is noticeable in what stages the fall out happens and at what rate - the funnel chart illustrates where the biggest bottlenecks are in the process.

Data like this sales pipeline data is best displayed using the funnel chart:

Donut Chart

Donut Chart displays data in a ring, divided into slices to illustrate numerical proportion.

See also: Pie Chart

Combination Chart

A combination chart allows combining multiple charts of different types together in the same report part.

• Comparison between Sales with and without Discount

  

• Relationship between ServiceTime and Sales

  

• Area type is available in Combination chart from version 2.12.0.

  

Tree Map Chart

Tree Map displays data as a set of rectangles. It is good for comparing proportions and spotting patterns. It can also display a large amount of items on the screen simultaneously.

A Tree Map comparing Products by their Units in Stock.

To configure the report like that:

1. Select “Tree Map” as the Chart Type in General Info group, two boxes will appear in Configuration section: “Labels (X-axis)” and “Values (Y-axis)”.
2. Add the field ProductName into Labels box (drag the field from Middle Panel or use the Add icon +).
3. The field will be given the alias “Group(ProductName)” (Group function is used as expected).
4. Add the field UnitsInStock into Values box (drag the field from Middle Panel or use the Add icon +).
5. The field will be given the alias “Sum(UnitsInStock)” (Sum function is used as expected).
6. Click the Report Part’s header to open Report Part Properties panel again.
7. In Data group, tick Show Value Labels and Show Slice Labels.

Heat Map Chart

Heat Map displays values in a matrix, with larger values represented by darker colors.

A Heat Map comparing Freights by Year and Country.

To configure the report like that:

1. Select “Heat Map” as the Chart Type in General Info group, three boxes will appear in Configuration section: “Labels (X-axis)”, “Values (Y-axis)” and “Value Label”.
2. Add the field OrderDate into Labels box (drag the field from Middle Panel or use the Add icon +).
3. The field will be given the alias “Group(OrderDate)”, Group as Function and Year as Format in Field Properties.
4. Add the field ShipCountry into Values box (drag the field from Middle Panel or use the Add icon +).
5. The field will be given the alias “Group(ShipCountry)” (Group function is used as expected).
6. Add the field Freight into Values box (drag the field from Middle Panel or use the Add icon +).
7. The field will be given the alias “Sum(Freight)” (Sum function is used as expected).
8. Click the Report Part’s header to open Report Part Properties panel again.
9. Click the gear icon next to Settings in Legends group to open Legend Settings pop-up.
10. Tick Visible check-box to show the legend.
11. Click OK to close the pop-up.
12. In Data group, tick Show Value Labels.

Scatter Chart

A scatter chart displays data as data points, at the intersection of an x and a y numerical value. For a scatter chart, both horizontal and vertical axis are value axis, there is no category axis like the line chart.

Above is a sample Scatter Chart Showing Number of Orders and Total Freight by Country.

• The countries that appear further on the right have more orders.
• The countries that appear higher on the chart have more total freight.

To configure the report like that:

1. Select “Scatter” as the Chart Type in General Info group, three boxes will appear in Configuration section: “Labels (X-axis)”, “Values (Y-axis)” and “Value Label”.

   For this chart, the numerical fields will be added before the categories/labels.

2. Add the field OrderID into Labels box (drag the field from Middle Panel or use the Add icon +).

3. The field will be given the alias “Sum(OrderID)” (not the Count function as expected).

4. Click on the field “Sum(OrderID)” in Labels box to open Field Properties box.

5. Select Count as the Function in Data Formatting group, the field is now given the alias “Count(OrderID)”.

6. Add the field Freight into Values (Y-axis) box (drag the field from Middle Panel or use the Add icon +).

7. The field will be given the alias “Sum(Freight)” (Sum function is used as expected).

8. Add the field ShipCountry into Value Label box (drag the field from Middle Panel or use the Add icon +).

9. The field will be given the alias “Group(ShipCountry)” (Group function is used as expected).

10. Click the Report Part’s header to open Report Part Properties panel again.

11. In Data group, tick Show Value Labels check-box.

Bubble Chart

Bubble chart is a variation of scatter chart in which the data points are replaced with bubbles, and the size of the bubbles represents an additional dimension of the data.

Above is a sample Bubble Chart Showing Number of Orders and Total Freight by Country.

• The countries that appear further on the right have more orders.
• The countries that appear higher on the chart have more total freight.
• The countries in bigger bubbles have more cities being shipped to.

To configure the report like that:

1. Select “Bubble” as the Chart Type in General Info group, four boxes will appear in Configuration section: “Labels (X-axis)”, “Values (Y-axis)”, “Value Label” and “Bubble Size”.

   For this chart, the numerical fields will be added before the categories/labels.

2. Add the field OrderID into Labels box (drag the field from Middle Panel or use the Add icon +).

3. The field will be given the alias “Sum(OrderID)” (not the Count function as expected).

4. Click on the field “Sum(OrderID)” in Labels box to open Field Properties box.

5. Select Count as the Function in Data Formatting group, the field is now given the alias “Count(OrderID)”.

6. Add the field Freight into Values (Y-axis) box (drag the field from Middle Panel or use the Add icon +).

7. The field will be given the alias “Sum(Freight)” (Sum function is used as expected).

8. Add the field ShipCountry into Value Label box (drag the field from Middle Panel or use the Add icon +).

9. The field will be given the alias “Group(ShipCountry)” (Group function is used as expected).

10. Add the field ShipCity into Bubble Size box (drag the field from Middle Panel or use the Add icon +).

11. The field will be given the alias “Count(ShipCity)” (not the Count Distinct function as expected).

12. Click on the field “Count(ShipCity)” in Bubble Size box to open Field Properties box.

13. Select Count Distinct as the Function in Data Formatting group, the field is now given the alias “Count Distinct(ShipCity)”.

14. Click the Report Part’s header to open Report Part Properties panel again.

15. In Data group, tick Show Value Labels check-box.

Waterfall Chart

A waterfall chart shows a running total as values are added or subtracted. It’s useful for understanding how an initial value is affected by a series of positive and negative values.

Sample report on Northwind database, “Summary of Sales by Year” view showing running sales by year.

To configure the report like that:

1. Select “Waterfall” as the Chart Type in General Info group, three boxes will appear in Configuration section: “Labels (X-axis)”, “Values (Y-axis)” and “Total Label”.
2. Add the field ShippedDate into Labels box (drag the field from Middle Panel or use the Add icon +).
3. The field will be given the alias “Group(ShippedDate)” (Group function and Year format are used as expected).
4. Add the field Subtotal into Values box (drag the field from Middle Panel or use the Add icon +).
5. The field will be given the alias “Sum(Subtotal)” (Sum function is used as expected).
6. Click the Report Part’s header to open Report Part Properties panel again.
7. In Data group, tick Show Value Labels check-box.

Sparkline Chart

Sparkline is a tiny chart, usually drawn without axis and labels. It provides a visual representation of data in a simple and compact way. It is most commonly used as embedded report.

Sample sparkline chart comparing the related total freight and number of orders by year.

To configure the report like that:

1. Select “Sparkline” as the Chart Type in General Info group, two boxes will appear in Configuration section: “Intervals (X-axis)” and “Values (Y-axis)”.
2. Add the field OrderDate into Labels box (drag the field from Middle Panel or use the Add icon +).
3. The field will be given the alias “Group(OrderDate)” (Group function and Year format are used as expected).
4. Add the field Freight into Metric 1 Value box (drag the field from Middle Panel or use the Add icon +).
5. The field will be given the alias “Sum(Freight)” (Sum function is used as expected).
6. Select Line as the Chart Type.
7. Click the Add Metrics at the end to add another Metric.
8. Add the field OrderID into Metric 2 Value box (drag the field from Middle Panel or use the Add icon +).
9. The field will be given the alias “Sum(OrderID)” (not the Count function as expected).
10. Click on the field “Sum(OrderID)” to open Field Properties box.
11. Select Count as the Function in Data Formatting group, the field is now given the alias “Count(OrderID)”.
12. Select Line as the Chart Type.
13. Click the Report Part’s header to open Report Part Properties panel again.

To be updated: screenshot of sparkline chart embedded inside a grid.

Others

• Grid view pop-up option. This option is available from version 2.10.0.

  Click icon to see the grid view of the chart data associated with the current drill-down level and metric.

  

- Metric drop-down.