There are two possible ways to add collected data against indicators on TolaData – ‘manually’ and ‘pulling data from the data table.’
How to add data manually?
Click on the ‘Indicator’ tab on the navigation bar, then go to the ‘Collected Data’ tab and click ‘Add new collected data’. Select ‘Manuel entry,’ enter your collected value and the date the data was collected. You can also link the result to one of your program’s project sites or link supporting evidence. Add additional notes if needed and add disaggregation data. When you’re done, click ‘Save.’
How to link tabular data evidence from Data Tables?
Your collected data value can also be calculated directly from your data set ensuring accuracy and traceability of your results.
First, you need to import your data into Data Tables or collect data using our customisable form builder and share it with your data collectors.
To link your data set to your indicator, open the indicator, go to the ‘Collected Data’ tab and then click ‘Add new collected data’.
Enter the date the data was collected. You can also link the result to one of your program’s project sites. Next, select the data table you want to use to calculate your selected value. The drop down list will show you all tables that are connected to this program in data tables.
Select the column of the data table that you want to perform the calculation on and then select what calculation formula you would like to use – row count, sum, average or median.
The calculated result will be displayed for you to verify. Click ‘Save’ and the collected value will be added to the results for this indicator.
How to add disaggregation data when you pull data from the data tables?
Once you’ve imported data in from your data table, you’re able to further break your indicator results based on the disaggregation types you added to your indicator.
If you are pulling data from the data table, then here’s how to add the disaggregation data – once you are in the ‘Collected data’ section, click on ‘Add new collected data’.
Fill out the ‘Evidence’ section and click on ‘+Add disaggregation data’ tab. Next, select the prefered ‘Disaggregation type’ and ‘Disaggregation column’ from the drop down menu. You can then map the disaggregation values to the data in your column and click ‘Save’.
How to add disaggregation data when you enter your data manually?
You can add disagreggation data to your collected result by clicking on ‘Add disaggregation data’. Any disaggregation types you have added to your indicator will be available for you to enter data.
Select the disaggregation type from the drop down list and then enter the values for each disaggregation value.
Top tip: you can add data for more than one disaggregation type on the same collected value by clicking on ‘Add disaggregation data’ again.
How to add conditions?
You can apply ‘conditions’ when you want only certain rows of your data table to be included in the calculation. This means your results will be filtered according to the condition(s) you set.
After selecting the data table and column for your collected value, click on ‘Add condition’. Select the column which has the data you wish to use for your condition, define how the condition should be applied (for example – do you want all rows equal to a value in your column or all rows greater than a value, etc), define the value to use and the result will automatically recalculate according to that condition.
You can add more conditions by clicking on ‘Add condition’ again.
How to link supporting evidence from cloud storage services?
Want to add some solid evidence to justify your results? No problem! In TolaData any kind of document stored on Google Drive can be linked to your indicator results. Simply select the ‘Google Drive’ button and choose the corresponding file from your Drive. You can choose any file type, be it Google Spreadsheet or a PDF file with a contract or partner agreement or just some certificates pertaining to your program.
Note: The first time you attempt to link your supporting evidence, you will have to provide authorization to TolaData to access your Google Drive.
Please contact us for integration with other cloud storage services!