Filter Data Tables by Linked Data

To start the year right, we've added a nice bit of functionality to linked data tables.

Previously, data tables could not be filtered using columns pulled in from a linked table. Now these filters are available in all linked tables.

In this example, the table Teachers is linked to two tables: Classrooms and Cohorts. You can now filter the list of teachers using information about classrooms (like Grade or Well-Supplied?) and/or by cohorts (like Intervention Type). The filter options appear on the left with the equivalent search string in the search box. The resulting view shows only rows where the classrooms are well-supplied and the cohort intervention type is "control".


We've also had several requests to enable export of all linked columns, and we'll work on enabling that as soon as we can.

Default target is now 0

Here's a final small improvement to close out 2019!

Previously, when you created a new target for an indicator, the default value was "1". We've changed it to "0", which makes more sense as a default.


Once you've added the target date, you can edit the target to a value of your choosing:


This update applies to both global and activity targets.

Happy New Year's Eve!

Small change to make "Activity Discussions" permission more accurate

It was brought to our attention that while the "Activity Discussion" permission defined view or view+edit access to the activity discussion board, access to the (activity) reporting period discussion board was linked to the permission governing indicator results. From now on, users with permission to view and/or edit activity discussion boards will be able to do so on any discussion board independently of their ability to view and/or edit indicator results.

Tl;dr - Permissions make a little more sense now:-)

Color order locked for disaggregations on targets/actuals graph

If you've ever added multiple tiles to a dashboard of indicators with similar disaggregations, you may have noticed that the colors applied to each disaggregation can sometimes jump around (a category that's red in one graph may be green in another). Now the order of disaggregations on your disaggregations page will dictate which category gets which color. Minor, but possibly useful!

Partner Dashboards

DevResults is excited to announce an update enabling partner dashboards! Please reach out to if you'd like to enable this experience for your partners. In the near future, you'll be able to select this option yourself in your DevResults settings page. For now, we're rolling it out gradually.

Recently, you might have noticed the updated look of the partner landing page. The information is now styled like a dashboard with three tiles.


Now, the new partner dashboard feature will let partners create their own dashboards, and users with the "dashboard manager" permission will be able to push dashboards to partners.


Every tile visible to a partner will be automatically filtered to show only information that relates to their activities, so enabling partner dashboards won't change access or permissions at all.

Heads up: New Password Requirements

DevResults continuously invests in protecting your privacy and security. We're rolling out a number of upgrades to keep our practices up to date. Most of these will be invisible from a user's perspective, but starting today, some users will be required to reset their passwords. To do so, click on the "reset password" button on the log in screen to get a new password. You're always able to change your password in your user profile page.

IATI Hub: support added for @humanitarian flag, first of several humanitarian items

Many International Aid Transparency Initiative (IATI) publishers are beginning to include additional humanitarian-only fields in their activity files, partly in response to the humanitarian community’s Grand Bargain reforms as well as the integration of the IATI data standard with the UN's Financial Tracking Service (FTS). Many more will begin to do so now that donors are rolling out requirements for their humanitarian partners and recipients.

In response, we plan to add several additional humanitarian fields to our IATI Hub tool in the coming weeks, but today we added the most basic: a checkbox to indicate whether or not an activity is related to humanitarian aid (the so-called "humanitarian flag" or @humanitarian attribute). By default, all activities are set to '0' or false, but you can change the status to '1' or true by going to the IATI tab for any Activity and ticking the box.


We'll keep you apprised as other small IATI updates roll out!

Sunsetting "Rate Per" Indicators

Less than half of 1% of indicators in DevResults are defined with the "Rate Per" number format, and less than half of those have any indicator results reported. This is a feature that adds complexity without adding value, so we're streamlining indicator definitions by sunsetting this option.

Introduced in DevResults' earliest days, the "Rate Per" indicator number format was intended to capture indicators like "number of live births per 1000 pregnancies". It captured that "1000" as a number in a separate field, but there has never been any functional difference between that and simply naming your indicator "number of live births per 1000 pregnancies". Either way, indicator results are reported as whole numbers or decimals and are calculated as an average across times and places.

As of now, no new indicators can be created with the "rate per" number format.

If your organization has any existing "rate per" indicators, a custom query has been added to your site with a list of these indicators at Tools > Custom Queries > "Rate Per" indicators. These indicators must be updated to Whole Number, Decimal, or Percentage by November 1st.

If you have any questions about this, please don't hesitate to reach out to us at

Filter indicators by activity

You can now filter indicators in the indicator index by which activities report on them! This is part of our work to make filtering, sorting, and exporting information from various DevResults indices as easy as possible. Please let us know about any other filters that might help you by reaching out to us at


Improved Partner Dashboard

Another small change from us this week: We've updated our partner dashboard so it looks a lot similar to a non-partner dashboard.

None of the functionality on this page has changed, but we'll hopefully have a few more updates to this page soon! rn-partnerdash.png

To find out more about partner functionalities, please refer to our Knowledge Base