Report on your field usage
You can run a report on how you use fields in different files with the with Field Usage Count tool. This can be helpful when cleaning up data.
Overview
A Field Usage Count report can show you all the fields in a particular file and how often they are used. This is useful for identifying fields that need to be updated. For example, if the field usage count for the Classification field does not match the total number of records included in the report, this could mean that some records need to have a classification term entered.
The Field Usage Count tool gives you information on:
-
The total number of records in a file.
-
The total number of fields in a file.
-
Which fields are being used.
-
Which fields are not being used.
-
The number of records using each field.
-
The internal field name of each field.
You can output your report to the screen, the printer, or a table. We recommend a table, as you can then copy the table to Excel to analyse the data and record notes.
Video
Steps
-
Go to the Tools menu, then Utilities, and then click Field Usage Count.
-
In the File Name field, enter a file to run the report on. For example, Object.
-
Optional: In the List Name field, enter a list. Leave this blank if you want to report on the whole file.
-
Optional: Tick the Show Unused Fields check box.
-
Under Send Report To, choose to send it to the screen, the printer, or display it in a table.
-
Click OK to run the report.
-
If you chose the table option, you can then copy the report to Excel. Go to the Edit menu and click Copy Table to Excel.
Reviewing your report
Here are some questions to consider when reviewing a Field Usage Count report:
-
Are there required fields that have not been completed for all records?
-
Are there any unused fields you would like to re-purpose by changing the field name?
-
For the Person file, do all records have a Record Type and Person/Corporate Type specified?
-
For the Photo/Audio-Visual file, do the total usage counts for the Non Digital Reference field and Digital Filename field add up to the total number of records?
-
For Activity files, do the Number of Items field and Item Description field have the same usage count?
-
For the Inward Loan file and Outward Loan file, do the Start Date and End Date fields have the same usage count?
You can find the records that are have incomplete fields by searching for an absence of data.