Reports charts/graphs

This guide will guide you through the process of adding a graph/chart to your reports and describe its properties.

How to add a chart

1. Create a copy of a report.

2. Edit the report or enter in View mode to open the report layout editor.

3. Right-click in the top-left corner and select > Insert chart (above/below).

mceclip5.png

4. The chart menu will open:

Example 1: number of events per asset

In this example, we want to create a chart for the Number of Events per Asset. We will position the events on the Y-axis and the assets on the X-axis of our graph.
mceclip3.png

Result

mceclip4.png

Example 2: distance traveled per asset

In this example, we want to display the distance travelled for each event that occurred. The parameters in the graph could be as follows:

mceclip0.png

Result

mceclip2.png

Chart parameters

  • Type: the different graphic options for the representation of the data in the chart.
  • Width/Height: if you want to limit the size of the chart in your report.
  • Title: this name will show up in the position selected in your chart.
  • Axis labels: the names of each axis in your chart.
  • Unit: you can choose if you want to convert the unit of the data in your graphics to a specified unit type (for example, if you have speed it shows the result in meters per second by default, you may want to select JOURNAL_DISTANCE to display correctly the results on miles or kilometers depending on your regional settings).
  • Min/Max values: you can put a limit to the number of data represented in your chart. For example, you have 1 column that shows 10 items and another that shows 10.000 the graph may become unreadable. You may want to set this to the limit of 100 for the maximum value.
  • Series Label: what data to display as labels on the legend

Fix interval: here you can set the number of label samples that you want to display over the line of the graph. If you select for example 1 it will show values one by one until it reaches the top (Max).Bar chart of vehicle data.Bar chart of vehicle data.

  • Split by: you can separate the results of your graph by different sorts of data depending on the available variables you have in the report. For example, in an ungrouped report by assets if you have 100 events and you will get only one column containing all the assets. On the other hand, if you use this parameter with the value [Name] for example, you will separate the graph by Asset Name and the assets will get different colors.

Bar chart of vehicle speeds.  Bar chart of vehicle speeds

  • Values: your variable name that you want to use in each axis. If you are not sure of the variable name, simply click on any empty cell and select the variable you need. Use the same name here.

Match columns with names

Here is a description of the graph type Stacked Column that can be used to match columns with labels on the x-axis in a better way than only using the type Column.

Example of using stacked column chart

mceclip0.png

mceclip1.png