Excel Reports: Set up additional data filters when you run an existing report

 

You can now add in Event Field filters when you run an existing Excel Report.

You can now add in Event Field filters when you run an existing Excel Report.

 

Tick on the "Advanced Configuration" button and then you will be able to add in a filter for the Event Form/s.

Tick on the "Advanced Configuration" button and then you will be able to add in a filter for the Event Form/s.

1: Click on the Advanced Configuration tick box

2: All of the Event Form used to create the Excel Report will appear for selection (the example here shows three beacuse this report was set up using three forms)

-Click on the "Add" button to add in an Event Form Filter

The example here shows that a filter is being set up for the Event Form Daily Monitoring and the Field "Hours Slept".

The example here shows that a filter is being set up for the Event Form Daily Monitoring and the Field "Hours Slept".

#1: Select the Event Field: e.g. Hours Slept

#2: Select the Condition: e.g. Greater than or equal to

#3: Select the Search Term: 7 (e.g. 7 hours or more)

When you have set up the appropriate filters, Run the Report

When you have set up the appropriate filters, Run the Report

 

Open the file and you will see that ONLY entries that match the filter criteria will be included in the Excel Report

Open the file and you will see that ONLY entries that match the filter criteria will be included in the Excel Report

 

0 Comments

Add your comment

E-Mail me when someone replies to this comment