Matrix is a powerful query tool for creating reports. Find Matrix in any indicator's reports tab.
The display section lets you choose how to slice, dice, and analyze your data. The filter section lets you choose a subset of your data to include. You'll also find the updated display and filter options on other visualization tools, including dashboard tiles for indicator results.
Here's a quick feature guide to get you started:
- Cross-disaggregated reports (new)
- Group reporting periods by fiscal year (new)
- Unlimited display disaggregations (new)
- Include actuals and targets (improved)
- Calculate percent of activity targets and global targets (new)
- View information incrementally or cumulatively (now including target analyses)
- Show or hide totals for each grouping/disaggregation (new)
- Expanded/improved filters for activities, organizations, disaggregations, geographies, and reporting periods.
The filters use "OR" logic within a single filter plus "AND" logic between filters. For example, if you choose two activities from the activity filter and two quarters from the reporting periods filter, you'll see data for for both activities, but only for the selected quarters.
This tool will replaced the Grid tool, and the other visualization options received the same improvements to the left-hand panel. In the long term, we're going to update Pito with the same advanced functionality.
Permissions required to use Matrix: view or view/edit for activity overview, indicator results, indicator targets, organizations, geography, and reporting periods.
Didn't answer your question? Please email us at firstname.lastname@example.org.