MultiMatrix is a powerful query tool for organizing and analyzing data for multiple indicators. MultiMatrix works just like Matrix, but for more than one indicator. MultiMatrix reports can be saved to a list of reports or as a dashboard.
Soon, MultiMatrix will replace Pito Reports.
In this article:
Create a MultiMatrix report
You can find MultiMatrix under the Data menu from any DevResults page. Configure the report using the options in the left-hand pannel.
- The indicator section lets you select multiple indicators to analyze.
- 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.
Select the indicators you would like to analyze by using the search bar to find your indicators by code or name. You can also unfold 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.
Scroll down further in the left-hand configuration panel to the display section to decide how to arrange your data. First choose how the data should be disaggregated. Arrange the disaggregations as rows/columns using the arrows next to each. (Flip all the row/column selections with the arrow square right above.) Then decide what values to show (actuals, targets, etc.). Decide whether results should be viewed incrementally or cumulatively, pick how to label the indicator, and choose whether or not you want to hide certain totals.
NEW: We have introduced a new option called "Disaggregation Category Combinations." This enables you to:
- Create reports with indicators that have different disaggregations
- Show results for each combination of categories for indicators with more than one disaggregation.
In the third section of the configuration panel, you can also filter data to specific activities, organizations, disaggregations, geographies, or reporting periods.
Save your report by clicking Save, giving it a title, and clicking Save again. (Here you have the option to save it as a report or as a dashboard.) To find your saved reports, right now you'll need to go to Data > Pito > Saved reports, but soon we'll add a link from this page.
Saving your report gives it a unique URL that you can give to anyone who has access to see that page. URLs saved reports contain ID numbers, like yoursite.devresults.com/en/dash/viewdata/results_preview?savedreportid=2126. A link without an ID will take someone to MultiMatrix, but they won't see your report.
Create a MultiMatrix dashboard
There are two ways to create a MultiMatrix dashboard. One option is to follow the directions above, but choose Save as dashboard at the end.
The other is to go to your Dashboard and select the +Add a dashboard button. Select MultiMatrix under Type. Give your dashboard a title and an optional description. As with any dashboard, you can elect to make the MultiMatrix dashboard available to others or private. Owners can choose to push MultiMatrix dashboards to other users.
Once you have created the dashboard, you can configure your MultiMatrix report. If you ever want to make changes to your MultiMatrix dashboard, click Configure in the bottom corner.
MultiMatrix for partners
Partner users can also use MultiMatrix to assemble reports and view their data. Partner users can create MultiMatrix dashboards, and owners can push MultiMatrix dashboards to users. For partners, all indicator data and program information is automatically filtered to just what the user has access to. There's no way for a partner to see data that doesn't belong to them, even if someone pushes a dashboard to them that has other projects' data. We filter it out automatically!
Didn't answer your question? Please email us at firstname.lastname@example.org.