In DevResults, you can review all data collected on your site and create spreadsheet reports with a wide range of layout options and filter criteria. This tool works like pivot tables in Excel, allowing you to aggregate, organize, and display your indicator results.
There are three basic steps:
- Select your indicators
- Select your filters
- Configure your rows and columns
You can then choose to download or save your report, and you can always make configuration changes to your own saved reports.
1. Select Your Indicators
Go to Dashboard > Pito.
Your report can include one indicator or many indicators -- whatever you want. Under "choose indicators", you can use the search bar to find your indicators by code or name. You can also unfolding the results framework by clicking on the triangles, then checking the box next to individual indicators or groups of indicators you want to include in the report.
If you want to include or exclude indicators based on indicator tags, use the Indicator types button at the bottom left-hand corner. This limits what appears in the results framework/indicator list. (You still need to check the boxes next to the indicators for your report).
The top checkboxes will show and hide inactive indicators, inactive results frameworks, computed indicators, component indicators (those used in other indicators' formulas), and inactive disaggregations. The next section will vary based on the indicator tags that exist in your site, but it will filter the tree above to show only indicators with the selected tag(s).
2. Select Your Filters
The top row of the main pane will Apply filters to the indicator data displayed below. Filters let you choose subsets of indicator results to include. For example, if you want to create a report with only data from 2018 Q3, you would change the reporting period filter from "any reporting period" to just "2018 Q3". To do so, click the dropdown next to any filter and check the boxes next to the items you want the filter to include. Filters include: reporting periods, partner organizations, activity tags, awarding organizations, and organizations.
In this example, the report will include only indicator results for the activities "Best Agricultural Research Program" and "Mosquitoes Are the Worst".
3. Configure Your Rows and Columns
Next, you'll choose your rows, columns, and whether you'll display actuals, activity targets, global targets, or any combination of those.
- Choose rows and choose Columns let you pick your rows and columns. You can choose both a primary display and an optional subdivision. In this screenshot, we've selected Indicator columns subdivided by Activity:
- Include lets you toggle between displaying indicator actual # (the actual performance data for this indicator), target # (activity) (activity-level targets set for this indicator), and target # (global) (site-wide targets set for this indicator).
You can also display data for individual disaggregations by checking the box for the disaggregation in the tree on the left. Here, we've displayed 1.2-a's Urban vs. Rural disaggregation.
4. Download Your Report
If you'd like to download your report to Excel to use it in other reports, import it to other tools, etc., click the Download button.
5. Save/Share Your Report
To save this report, go to the Saved reports dropdown and click on Save report.
Give the report a name and click Done.
Now you can see your report under the Saved reports dropdown under My saved reports.
When you open a saved report, the URL (web address) for the report is permanent. You can send that link to any users who have permission to view Pito reports.
Sharing a report gives other people read-only access to the report. If they want to edit it or make configuration changes, they will have to Copy report to make configuration changes.
Didn't answer your question? Please email us at email@example.com.