A filtered dataset is a subset of form submission data that fulfills certain conditions set by the user. They are useful when you want to share a dataset with other people, but would like to keep certain fields or records private.
Filtered datasets allow you to select certain fields from the data you’d want to show, enabling you to hide data such as names or sensitive details. You can also filter responses so records only appear if specific answers show up.
Access to filtered datasets works the same way as datasets projects. You can save it to a different project than the original parent dataset and control who has access to the data.
Filtered datasets can be created from a form (with submissions) using the Create filtered dataset option in the form’s dropdown menu. Below are the steps to follow to create Filtered Datasets:
In the next step, you can Add filters to show records that match specific answers to fields. For example, if you have a field for “Gender of household Head”, you can add a filter for “Female” (in our dataset , the option “Female” is represented by the variable name “2”) so that only records that answered that field with “Female” show up in the filtered dataset and records that have the answer “Male” are hidden. There is more information on this step below in the How filters work section. Click the Next button when you are done adding filters.
To Confirm and Save your created filtered dataset, enter the Name of linked dataset in the textbox.
From the Project dropdown menu, select the project you’d like the filtered dataset to be placed in. If you’d like filtered dataset to be placed in a different project than the original parent dataset select the New Project option.
Once you’re done click on the Save button.
- A filtered dataset inherits the same permission settings as the project it is in. The permissions of the parent dataset does not impact the permissions of the child filtered dataset.
- If you choose to hide fields in a filtered dataset, editing records in that filtered dataset will be disabled for all users. Read more about why in the When editing becomes disabled… section below.
Filters in filtered datasets allow you to show only records with specific answers. In other words, if you were viewing the data table, only show specific rows with fields that match your filter would show and rows that do not will be hidden.
After selecting the fields you want to show (step 3 above), you’ll navigate to the Add Filters page. To add a filter follow the steps below:
You can add as more filters by clicking on the Add Filter button.
Records in a filtered dataset are not actually new, duplicate records — they are the same records of the parent dataset with hidden information. For adding and editing records, this has a few implications:
For new records: records cannot be added to the filtered dataset, they must be added to the parent dataset. Otherwise, there is a chance that the new submission won’t match the filters of the filtered dataset. A user must have Can Submit or greater permissions on the parent dataset to be able to do add new records to the parent dataset.
For editing records: when those records are edited from the filtered dataset, the data in the parent dataset is changed. Therefore, all of the “child” filtered datasets of the parent dataset will reflect the changes.
Filtered datasets are a helpful way to share information without compromising private data. However, because Ona data is form based, data editing is implicitly tied to the form. This means editing data is done through the form which must be shown in its entirety due to technical reasons — which in turn means editing data must be disabled when fields are hidden in order to ensure privacy permissions are upheld.
XLS Reports are not yet supported for filtered datasets, hence the XLS Report link is disabled on filtered datasets.