Why does my Pito report have Undefined data?

Broadly, the answer is what we show you in the site: "The data here is not categorized by the rows and columns you've selected." But what does that mean to you?

Well, there are a number of reasons you might see this error. Here are the most common:

My report's "Undefined" row/column has program targets in it.

Cause:

Program targets are set site-wide. DevResults doesn't currently allow you to enter program targets specific to disaggregations or geographies within an indicator, so if you're displaying program targets and you have rows/columns defined using geographies, locations, activities, or disaggregations, all target numbers will appear as Undefined. In the screenshot above, the targets are displaying as Undefined because we're using a Geography for the rows.

Solution:

1. Remove targets (program) from your report.

2. Adjust your rows/columns to something that can have program targets directly assigned to it (Indicator, Reporting Period, etc.).

My report's "Undefined" row/column has activity targets in it.

Cause:

DevResults doesn't currently allow you to enter activity targets specific to disaggregations or geographies within an indicator, so if you're displaying activity targets and you have rows/columns defined using geographies, locations, or disaggregations, all activity target numbers will appear as Undefined. In the screenshot above, the targets are displaying as Undefined because we're using a Geography for the rows.

Solution:

1. Remove targets (activity) from your report.

2. Adjust your rows/columns to something that can have program targets directly assigned to it (Activity, Indicator, Reporting Period, etc.).

My report has Activities as rows or columns followed by "Undefined."

Cause:

Your report includes indicators that are not set up to report separately per activity. The system can't assign it to an activity, so it puts it in an "Undefined" column.

Solution:

1. Remove any indicators not set up to report separately per activity.

2. If you don't know which indicators those are but you know you don't need the performance data in the Undefined line, click the "for any activity" dropdown and select the activities you wish to see. The Undefined column/row will disappear.

My report has Partner Organization or Awarding Organization followed by "Undefined."

Cause:

This has one of two possible causes:

  1. Awarding organization and partner organization can only be linked to indicators through activities, so if you have indicators that aren't set up to report separately per activity, those indicators' data will show up as Undefined.
  2. Activities contributing to these indicators may not have awarding organization or partner organization assigned and will thus show up as Undefined.

Solution:

First, modify the report to try it with Activities instead of the Organization. If running the report with Activities doesn't remove the Undefined column, then it's Cause #1 and you can use one of these solutions:

  1. If there are indicators not reporting per activity, remove these from your report.
  2. If there are indicators not reporting per activity but you don't know what they are--and you know you don't need the data in the Undefined line--click the appropriate filter ("awarded by any awarding organization" for Awarding Organization or "implemented by any organization") and check all the organizations you need. The undefined column/row will disappear.

If running the report with Activities does remove the Undefined column, then it's Cause #2 and you can use this solution:

  1. You or your site administrator will need to edit the Activities missing organizations. You can check the Activities index (by clicking Activities) and click Choose Columns to show Partner and Awarding Organization to identify activities that don't have an organization assigned.

My report has Geographies or Locations followed by "Undefined."

Cause:

First, check whether you're displaying targets or actuals. If the problem is only with targets, targets cannot be assigned to geographies; see this entry above.

Actuals displayed by geography show an "Undefined" column when you've selected a Geography column that is more granular than the geographic reporting level of one or more of your selected indicators. For example, if you've selected "Location" as rows or columns, but you have indicators reporting at the Country level, those actuals will display as "Undefined."

Solution:

You have two options:

  1. If the geographic level you've selected as rows/columns is important, you must remove the indicators reporting at a lower geographic level to get rid of the Undefined column.
  2. If it's fine for you to edit the geographic level, simply change your geography row/column setting to the next higher level until the Undefined column disappears.

My report includes Disaggregations for individual Indicators and some Indicators show "Undefined" instead of disaggregations.

Cause:

Adding disaggregation for an individual indicator is essentially like saying that you want to display Indicators Broken Down By Disaggregations. Pito tries to create the same high-level and nested structure for every indicator. If an indicator displayed has no disaggregation, then Pito will create an Undefined disaggregation with one Undefined row to hold and display the data.

Solution:

You have two options:

  1. Remove any indicators that don't have disaggregations from your selected list.
  2. Keep all indicators but don't display disaggregations for any of them (uncheck any boxes checked in the tree on the left next to the disaggregation title).
Didn't answer your question? Please email us at help@devresults.com.