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:
|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.
|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.
|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:
|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
Was this article helpful?
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
We appreciate your effort and will try to fix the article