search

devinit / ddw-analyst-ui

The Development Data Warehouse
http://ddw.devinit.org/
GNU General Public License v3.0
2 stars 1 forks source link

Create a new humanitarian_statistics table #775

Open akmiller01 opened 2 years ago

akmiller01 commented 2 years ago

Create a new table that is run outside of the IATI refresh/reload process that is capable of reducing the raw_iati_activities, raw_iati_transactions, and iati_publisher_frequency table into statistics about humanitarian publishers. Until the iati_publisher_frequency table can be populated with enough timestamps to make meaningful use of it, the frequency statistics may need to be replicated from another source of data.

wakibi commented 2 years ago

Hi @akmiller01, where do you suggest we get the frequency statistics from in the time being? And what would be a good threshold to start using our own?

akmiller01 commented 2 years ago

Probably http://publishingstats.iatistandard.org/timeliness.html

If we borrow the same methodology, we could start with that as a foundation and build our own data on top of it, so that we could start using our own after 1 month.

stale[bot] commented 2 years ago

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.