Resources

For numerical values in form submissions you can get the following computations: Sum, Averages, Count, Maximum, Minimum, Standard Deviation, Standard Deviation (Sample), Standard Deviation (Population), Variance, Variance (Sample) and Variance (Population). Look at the analysis section of the walkthroughs for practical examples on this.
To get the results of these computations click on Data Analysis -> Aggregates/Chart Based Analysis. Select the form you wish to analyze in the Primary Form dropdown box. In the Form Field section check the name of the numerical field you are interested in. Click on the name of the numerical field. In the dialog box presented click on the computation you’d like to carry out on the values of this field. The returned computational results can be grouped based on a certain form field. See FAQ 4 for more on this. You can also choose to view this results as tables, charts or download same. See FAQ 3 on how this is done.

Computationally, occurrences of textual data can be counted. This can be done by clicking on Data Analysis -> Aggregates/Chart Based Analysis. Select the form you wish to analyze in the Primary Form dropdown box. In the Form Field section check the name of the textual field you are interested in. The returned computational results can be grouped based on a certain form field. See FAQ 4 for more on this. You can also choose to view this results as tables, charts or download same. See FAQ 3 on how this is done.

There are 7 ways in which computed data can be viewed. These options include viewing result sets (1) in a table, (2) as a Bar chart, (3) as a Pie chart, (4) as a Line chart and (5) as an Area chart. Alternatively, these result sets can be downloaded and viewed in the (6) JSON format or converted to the (7) Excel format using the CCA Desktop app. A demonstration result presentation and data conversion are discussed in Example I of the walkthroughs.

Yes, you can. Consider an example where you want to retrieve the average population of countries in 1950 segregated or grouped by countries. To accomplish this, click on Data Analysis -> Aggregates/Chart Based Analysis. Select the form you wish to analyze in the Primary Form dropdown box. In the Group By Field dropdown box select the field to group the results by. In the Form Fields section, check the fields of interest. Click on your viewing option to get your results (See FAQ 3). A demonstration is presented in the analysis and download sections of Example I of the walkthroughs.

Click on Data Analysis -> Aggregates/Chart Based Analysis. Select the form you wish to analyze in the Primary Form dropdown box. In the Form Fields section, check the fields of interest. Click on the Filter icon. Select the field you wish to filter the results by in the Select Filter Field dropdown box. Choose the operator to apply to this filter in the Select Filter Operator dropdown box. Now select, enter or choose the value to filter by. Finally, click the Add Filter button. Repeat these steps to add more filter conditions, if necessary. When this is done, click close and then click on your viewing option to get your results (See FAQ 3). A demonstration is presented in the analysis section of Example I of the walkthroughs.

Encrypted data can only be analyzed offline as only the form designer has the private key to decrypt the encrypted data set. As shown in Example III of the walkthroughs, data can be decrypted to the JSON or Excel formats using the CCA Desktop app from where analysis can be carried out.

Yes, it is possible. Simply click on Data Analysis -> Download Data Subset. Select the form whose submissions you wish to download in the ‘Form’ dropdown box. If you intend to download only a subset then apply the filtering technique discussed in FAQ 5. To download all submitted data for a form skip the filter aspect. When done, click on the Download as JSON or Download as Excel button to get the result set in your preferred format.

Click on Data Analysis -> Delete Data Subset. Select the form whose submissions you wish to delete in the ‘Form’ dropdown box. Apply the filtering technique discussed in FAQ 5 and click the delete button. Please note that this process is irreversible.

Yes, you can by downloading the submitted data as described in FAQ 7 above and FAQ 5 here. Most analytical tools will accept data in the JSON format but where you want this data in the Excel format use the CCA Desktop app to convert the JSON data dump to an Excel file as described in the download section of Example I of the walkthroughs.

Yes, you can, as long as these forms share fields with similar names and types. An example of how to accomplish this would involve clicking on Data Analysis -> Aggregates/Chart Based Analysis. Select one of the form you wish to analyze in the Primary Form dropdown box. In the Secondary Form dropdown box select the other forms you wish to include in the analysis. In the Form Fields section, check the fields of interest. Now click on your viewing option to get your results (See FAQ 3).

Click on Data Analysis -> Map Based Analysis. Select the form you wish to analyze in the Primary Form dropdown box. In the Form Fields section, check the location field of interest. In the Select Annotation Field select the form fields you’d like to describe each location point. At this juncture, you can apply a data filter using the mechanism described in FAQ 5, if required. Finally click on the Get Locations icon button.The first 30 locations will be displayed on the map. Click on the marker of each location to display its caption data. To view the next 30 or previous 30 locations click the Next Page or Prev. Page button, respectively. A demonstration is presented in the analysis section of Example I of the walkthroughs

Click on Data Analysis -> Photo Based Analysis. Select the form you wish to analyze in the Primary Form dropdown box. In the Form Fields section, check the pictorial field of interest. In the Select Annotation Field select the form fields you’d like to caption the pictorial data with. At this point you can apply a data filter using the mechanism described in FAQ 5, if required. Finally click on the Get Photos icon button. The first 30 photos will be displayed alongside their caption. To view the next 30 or previous 30 photos click the Next Page or Prev. Page button, respectively.A demonstration is presented in the analysis section of Example II of the walkthroughs