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:


FilterDescription
FieldFrom the dropdown choose a field to filter on
Filter HowThis option dictates how you are checking the value of the field, for example Equals, Less than, Greater than, Is in list etc
CriteriaThis 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/OrChoosing ‘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 TypeDescription
AreaSimilar to the Line chart with the space below the line shaded
BarA conventional horizontal bar chart with the number of events on the horizontal axis
ColumnA bar type chart with columns showing the number of events on the vertical axis
LineA line chart showing the rise and fall of the number of events
RadarA radial chart showing the number of events
Stacked ColumnIf 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 CategoryDescription
By TypeShows number of events by event category
By FieldShows 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 TimeShows number of events for the date range specified in the dataset split by months of the year
By WeekdayShows number of events per weekday
By Weekday AM/PMShows number of events per weekday splitting out into morning and afternoon
By WeekShows number of events by week for the date range configured in the dataset
By DurationShows number of events for set time intervals
By ProgrammeShows number of events by programme
By ResidenceShows number of events by residence type
By StudentShows number of events per student
By AgeShows number of events for 17 and under, and for 18+
By LocationShows number of events per location
By Time of DayShows number of events for before, during and after the day
By Body MapShows number of areas selected on body maps within events
Top TenShows 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:


OptionDescription
Load Text ReportLoads a previously created text report
Edit FieldsSelect 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


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article