9/6/2023 0 Comments O data table creatorThen click (+) Create Data Table to save. You can then select whether you want to import the data in your spreadsheet, or if you want to create a data table without importing existing data. You can also auto-populate disaggregation values into an existing disaggregation by checking the "Auto add new values?" button or create a new disaggregation by typing in a new disaggregation title into the dropdown menu after selecting "Disaggregation". If the system-suggested type is incorrect, you can change this by clicking on the dropdown or by starting to enter the correct column type into the field you want to change. You will then be prompted to verify what type of data is in each of your columns. If you are using a multi-sheet Excel file, you will be asked to choose which sheet you want to upload. If you currently store your data in an Excel spreadsheet, or if you're importing data from a third-party system, you can upload this information to DevResults directly.įirst go to the Data Tables page and select (+) New data table.Ĭhoose a file from your computer or drag and drop a file from your computer to the page. You would not have separate columns for each gender.īack to top Creating a Data Table by Uploading a Spreadsheet A column for each disaggregation of any indicators that pull from this table: If you're disaggregating by gender, the column heading would be "Gender", and the rows in that column could contain "Male", "Female", etc.Are you counting dollars or euros? You'll need a column to enter those values. Patients? You'll need a column for each patient's ID or pseudonym. A column for what you're counting: Are you counting trainees? You'll need a column to list each trainee's ID or pseudonym.Exceptions include national-level indices (such as literacy rate, which don't represent work attributable to one of your activities) or internal metrics (like staff or budget records). Activity: If the records in the data table are attributable to activities, you must include an activity column to label each record with the relevant activity.(If you don't include a geography column, any data from the table will be associated with your top-level administrative division, like the whole world or the whole country.) Place: If records in the data table are associated with geographic places, you must include a column for the type of geographic place the records relate to, such as location, district, or country.The date is used to associate each row with a reporting period. Date: Your data table must have a column for date. If you want to pull indicator data from a data table, you must have a minimum set of fields for the data to be well-defined: For a quick breakdown on when to use data tables or direct entry indicators, take a look at the Indicator Guidebook. In fact, data tables can inform multiple indicators. Click here to learn more about How Activities are Linked to Data Tables.ĭata tables can serve as stand-alone repositories of information or databases, or they can be set to pull indicator results from these tables. Partners cannot see rows of data entered by others' activities. Any information added by a partner will be automatically labeled with their activity. Partners can access and edit data tables if you so choose, but only the rows of data that are associated with their activities. Columns for dates, numbers, and true/false restrict data entry to those kinds of values. Columns for activities, disaggregation categories, and geographic places use drop-downs to select those fields. Columns in data tables are defined with types that only allow certain inputs. Creating a data table from a custom queryĭata tables enforce good data practices.Creating a data table by designing it online.Creating a data table by uploading a spreadsheet.Data tables can have as many columns as you want, including text fields that allow you to store additional qualitative information for each row. Data Tables in DevResults allow you to directly upload spreadsheets of individual-level records and other raw data like tables of organizations, policies, and events.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |