Download USER GUIDE

3. Report Filter—The Report Filter area is the area that determines how you want to filter the data
presented on the table. For example, if you wanted to be able to view your data according to
the year that the incident was reported, you would drag the field ‘INCIDENT REPORT DATE
(YEAR)’ to the Report Filter area. Once the field is put into the Report Filter area, a report filter
will appear above the pivot table.
Note: On the provided pivot tables in the IR, most pivot tables already include the following report
filters: INCIDENT REPORT DATE (MONTH/YEAR), INCIDENT REPORT DATE (QUARTER), INCIDENT REPORT
DATE (YEAR) and ‘EXCLUDE FROM STATISTICS/ CONSOLIDATION.’ When creating inter-agency reports,
this makes creating reports based on month, quarter and year very easy. If you want to display data for
March of the year 2009, for example, you simply select that month and year from the dropdown list and
leave the Quarter as “all”. The parameters of the table will remain the same, but the numbers will
change according to the month and year that the data was inputted into the Incident Data worksheet.
When ‘(All)’ is selected rather than a specific month and year, all the data relevant data is displayed
regardless of when that data was reported. If your organization is part of an inter-agency group and will
be sharing information, using ‘EXCLUDE FROM STATISTICS/ CONSOLIDATION’ as a filter will help to avoid
duplicate reporting as it filters those survivors who have previously reported this incident to a GBVIMS
organization or agency.
6.18
CHAPTER 6: USING THE INCIDENT RECORDER FOR REPORTING AND FOR DATA ANALYSIS