This guide will guide you through the process of adding a graph/chart to your reports and describe its properties.
The necessary steps to make this modification are the following:
- Create a copy of your report
- Add the chart to your report
- Create and Activate your report in your Application
Create a copy of your report
To create a new copy of your report, go to the Site Admin -> Reporting -> New and select the report you want to modify (in this example we will use the EV1000 Event Rules report).
Add the chart to your report
To add a chart to your report you have to position the cursor on the cell you want to add your chart, above or below. Then right click on it and select -> Insert new chart (above/below)
Create and Activate your report in your Application
Follow this guide to activate and generate your report in your application.
Description of the parameters in the chart
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 an specified unit type (for example if you have Speed by default shows the result in meters per second, you may want to select JOURNAL_DISTANCE to display correctly the results on miles or kms depending on your regional settings).
Min/Max values: you can put a limit to the number of data represented in your chart. For example if 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.
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).
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 vehicles if you have 100 events and you will get only one column containing all the vehicles. On the other hand if you use this parameter with the value [Name] for example, you will separate the graph by Vehicle Name and the vehicles will get different colors.
Values: here you use 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.
Example 1: number of events per vehicle
In this example we want to create a chart for the Number of Events per Vehicle. We will position the Events on the Y axis and the Vehicles in the X axis of our graph.
Example 2: distance travelled per vehicle
In this example we want to display the distance travelled for each Event occurred. The parameters in the graph could be as follows:
Match columns with names
Here is a description of the 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.