search

devinit / datahub-cms

A better organised version of https://github.com/devinit/digital-platform to act as a CMS for the Data Hub
0 stars 5 forks source link

Humanitarian finance data should be multiplied to have it in millions. #24

Open epicallan opened 6 years ago

epicallan commented 6 years ago

The data in the humanitarian finance table [data_series.in_ha] is currently in values that one ought to multiply by 10^6 to have it in right values. Could you please do this at the database level.

dw8547 commented 6 years ago

@epicallan, here is a snapshot from the data_series.in_ha table for year = 2014 showing the top 10 recipients of HA:

screenshot from 2017-09-07 09 51 04

The values in the table are in the units of 10^6 already. E.g., Jordan:

screenshot from 2017-09-07 09 54 11

Jordan entry in data_series.in_ha:

screenshot from 2017-09-07 09 55 22