Event Log Reporting

Created by Duncan Harbour, Modified on Tue, 7 Feb, 2023 at 12:55 PM by Duncan Harbour

Various styles of report can be created for event logs. These reports are based on event logs between two dates, and based on set criteria (datasets).

Locating the Event Log Report screen

To set up event reports go to Event Log in the navigation menu and choose the Reporting option.

By default you start with a blank slate, so the first thing to do is to have a dataset to work with. You can add a new dataset or load an existing dataset which you have previously created and saved.

A dataset provides the criteria for the data to be retrieved. You can set the date range for the report and event fields to include in the report. The resulting data can then be used to create the reports and charts based on the chosen criteria.

Click Load Dataset to load up an existing saved dataset. For example, you may have configured a datasets covering each academic year. You can add, and use, more than one dataset so that you can compare similar information. For example, you could compare two different academic years.

Tip
A 'Dataset' is a term used here to identify a list of filters or criteria. So a dataset is simply a list of fields in Databridge you wish to use to filter your report.

Adding a Dataset

To create a new dataset, click Add Dataset and choose a meaningful name for your dataset. This name will appear in the legend on any charts.

Click Add Range to add a date range for the dataset. There are several date ranges to choose from which should cover all requirements. If you need anything outside of this you can add dates manually instead.

Click Add Filter to configure what data is to be gathered, which yields the following options:

Filter	Description
Field	From the dropdown choose a field to filter on
Filter How	This option dictates how you are checking the value of the field, for example Equals, Less than, Greater than, Is in list etc
Criteria	This field populates with comparison criteria that relates to the Field chosen. For example, if you chose a Date as the field, it shows a date picker, choose Site it will give a dropdown of available Sites
And/Or	Choosing ‘And’ will filter according to this configuration as well as any following filter option, both need to match to pick up the data. Choosing ‘Or’ will filter on this configuration or any following filter option, either need to match to pick up the data

Tip
Click Save if you wish to use this dataset again in the future

Generating a Report

Some charts are more suited than others for your chosen dataset. There are several chart types to choose from as well as what kind of chart is displayed. Choose the Chart Type from the first dropdown.

Chart Type	Description
Area	Similar to the Line chart with the space below the line shaded
Bar	A conventional horizontal bar chart with the number of events on the horizontal axis
Column	A bar type chart with columns showing the number of events on the vertical axis
Line	A line chart showing the rise and fall of the number of events
Radar	A radial chart showing the number of events
Stacked Column	If you have two or more datasets loaded this will show single columns including the number of events for each dataset

Information
If the Float Legend option is ticked then a legend is shown which will show the colour code used for each dataset in the chart. It can be dragged to any position in the panel for clarity.

Choose the category option (normally the horizontal scale) for the chart by choosing from the second dropdown.

Chart Category	Description
By Type	Shows number of events by event category
By Field	Shows number of events per specified field specified in the dataset – you choose the field from a new dropdown that appears. You must select a Category in the dataset for this to populate
By Time	Shows number of events for the date range specified in the dataset split by months of the year
By Weekday	Shows number of events per weekday
By Weekday AM/PM	Shows number of events per weekday splitting out into morning and afternoon
By Week	Shows number of events by week for the date range configured in the dataset
By Duration	Shows number of events for set time intervals
By Programme	Shows number of events by programme
By Residence	Shows number of events by residence type
By Student	Shows number of events per student
By Age	Shows number of events for 17 and under, and for 18+
By Location	Shows number of events per location
By Time of Day	Shows number of events for before, during and after the day
By Body Map	Shows number of areas selected on body maps within events
Top Ten	Shows the top ten for number of events by Student/Learner
Text Report *	Produces an onscreen tabular report – you can choose to print or export the results to Excel

Information
* For printing text reports there is some further configuration required

All charts in Databridge have an icon in the top right corner known as a burger icon. Click this to get options to export the chart as a picture, pdf or even Excel data (csv).

Tip
You can add as many datasets as you like. Doing this creates a comparison report as the charts will split by each dataset, this lets you compare date ranges, categories, students, staff, locations, anything you like including any fields manually set on an individual Category.

Printing a Text Report

To print a text report, you must specify which fields to include in the report, in addition to loading or adding a dataset. The data must be generated before printing the report.

After selecting Text Report further option buttons are shown as below:

Option	Description
Load Text Report	Loads a previously created text report
Edit Fields	Select which fields you want to include in the report

Run Report generates the data for printing or exporting. Data will appear in the main panel.

Once the data has been generated you can Print results or Export Results to an Excel file.

Tip
You can Save the Report if you want to be able to load the report later