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.
Select your indicators on the lefthand side by unfolding the results framework or searching it and then checking the box next to individual indicators or groups of indicators you want to see.
Use the Indicator types button at the bottom left-hand corner to filter the results frameworks and indicators:
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. 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.
3. Configure Your Rows and Columns
Next, you'll choose your rows, columns, and whether you'll display actuals, activity targets, program 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 # (program) (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 firstname.lastname@example.org.