How to understand your export.


To learn how to create an export view Exporting Your Data



When users open up the Excel workbook, they will see multiple tabs: 



The difference between ‘Named’ tabs and ‘Coded’ tabs is that the named tabs contain the actual responses, whereas the coded tabs contain responses in numeric codes, and the corresponding codes are available in the ‘Data Dictionary’ tab. Coded tabs are useful when you want to run a statistical analysis using a different software. 


Open either the ‘Level 0 Named’ tab or the ‘All Levels Named’ tab. Each column is a question listed in the order of the questions in the Form Builder. Each row is a patient record. 


Scroll to the far right to view all columns. The first column ‘time_created’ all the way to the ‘collection_round’ at the end are the metadata that Dharma collects. 

Column types: 

  • ‘Time_created’ and ‘time_updated’ columns are timestamps in the GMT time zone. 

  • ‘Created_by’ column indicates the username that created the record.

  • ‘Updated_by’ column indicates the username that may have updated/edited the record at a later date/time. 

  • ‘Delete’ column displays information on whether records have been deleted. Before doing any analysis with the Excel data, remember to check the delete column as a first step. Any and all records get logged in the export, even deleted records. As Data Collectors may have deleted some records during the data collection process, it is important to exclude those records when performing analysis. 

    • Deleted=False means record has not been deleted. 

    • Deleted=True means record has been deleted. 

    • Remember to filter for Delete=False records for analysis. 

Differences in export per data structure

  1. Single point

    1. Level 0 = All Levels

  1. Longitudinal

    1. Level 0 = Enrollment level

  1. Level 1= Multi-input level

  1. All Levels = Both Levels 0 and 1 combined



  1. Hierarchical

Similar to longitudinal, there will be additional tabs in the excel export depending on how many levels were configured for a project.  

  1. Case Management 

Enrollment project export: 

 


Intervention project export: 

As a case management project is connected by multiple single point projects, an export needs to be downloaded individually per project. Use the common columns (enrollment: concat field, intervention: reference field) to perform a vlookup outside Dharma to connect the datapoints.


Did this answer your question?