Country percentages - how do you represent change over time?

We have an example of an organisation where the percentage of funding going to each country has changed over the lifetime of the project. How would the organisation handle this in the data? How could you retain a historical reference in the data to the original set of countries so that you can see how the country focus has changed over time?

Any help appreciated - this is a live problem that we are trying to find a solution to!

Would specifying the country at transaction rather than activity level help here @SJohns ? That way any countries that become recipients at a later stage would only appear in the transaction at a later date in the project lifecycle?

Hi Wendy, this may be an option for some organisations. The additional challenge with the organisation I am working with is that it is subject to both MFA and DFID requirements, and these funders ask for countries to be recorded at activity level. The Standard doesn’t allow countries to be recorded at both activity and transaction level in the same activity. Any solution for this one?

I would suggest publishing the most recent country and region percentages available. It is up to the consumer of the IATI data to build an historical record of country and region percentages, if they are interested in these changes.

The alternative would be to extend the standard with a start and end date for the country and region percentages. This would introduce a lot of additional complexity though and I doubt the benefits would outweigh the costs.

I agree with Herman. For what it’s worth, it’s the approach we take - update countries/regions (and sectors) in our system and IATI files as the project evolves. This can create discrepancies in our data, for instance between what was reported to the DAC at the beginning of the project and what’s in our current IATI files 2 or 3 years later, but that comes with the territory - IATI is meant to provide timely, up-to-date data, not a statistical record.

It’s an interesting question nevertheless. @SJohns, are the organizations having problems in their reporting because of the changes, ie is anyone actually asking for the changes to be recorded?

I wonder is an easier solution would be to add an attribute to the country/region percentages indicating if they are modified. Data users for whom this is important could seek details from the publisher?

Thanks for the feedback - I think this is the approach I’ll suggest to the organisation I am working with. There’s no user need (in this instance) to show changes over time so it makes sense to follow this approach.