Datasets or Custom Fields can be used to create additional databases of information i.e. car databases, dog databases or to help you track and manage licences and renewals. Advanced Reporting features allow you to search per dataset i.e. per car.
Note: Datasets are an optional add-on. If you can't see them on your site and want to find out more, please raise a support ticket here.
Once you have setup your datasets and have data entered you will be able to access advanced reporting functionality via Membership > Reports > Dataset Reports
Select from the dropdown list at the top, which Dataset you would like to report on
Filtering and Searching
After selecting. your dataset report from the dropdown list, you can then customise your search.
You can filter on a number of fields that are standard across all datasets:
- Member Keyword
-
Member Expiry Date
-
Member Join Date
-
Dataset Created Date
-
Dataset Modified Date (the dataset modified date shows anytime a dataset has been saved, even if a change may not have been made)
Then all Fields that are all specific to your Datasets will appear with relevant filters i.e. Date Range filters for date field types, dropdown boxes for select boxes.
Advanced Filters
The final filters allow you to filter on the Member Status and also an option to Show Only Deleted Dataset Items (as shown below)
On the right hand side of the screen you will also see the option to choose which fields you wish to display on your screen and in your exports.
- Add additional fields,
- Reorder Fields - Drag and drop the field order using the +
- Delete the fields using the bin icon.
Exporting Datasets
Your have two options for exporting your data
- Export Displayed Fields - will export all of the fields that you have selected and have shown on your screen report plus created, last edited and deleted date where applicable.
- Export All Fields - will export all datasets fields plus member demographic information.
