Skip to content
This repository has been archived by the owner on Mar 26, 2019. It is now read-only.

Is the end date of a date range for an indicator correct #345

Open
cjhendrix opened this issue Mar 23, 2015 · 3 comments
Open

Is the end date of a date range for an indicator correct #345

cjhendrix opened this issue Mar 23, 2015 · 3 comments

Comments

@cjhendrix
Copy link
Contributor

The end date for indicators is Jan 1 of the latest year with data. However, shouldn't it be Dec 31?

Example: https://data.hdx.rwlabs.org/dataset/total-number-of-children-with-fever-who-received-treatment-with-antimalarial

@cjhendrix
Copy link
Contributor Author

Tagging @seustachi @alexandru-m-g

@alexandru-m-g
Copy link
Member

If I'm not mistaking the period is computed as min and max dates from all CPS indicator values start date property.
If the data that is imported in CPS has dates that only specify the year, we save that as Jan 1.

@seustachi
Copy link
Contributor

Indeed Alex, these are the start dates

SELECT MIN(i.start), MAX(i.start) from Indicator i WHERE i.source.code = :sourceCode AND i.type.code = :indicatorTypeCode

@danmihaila danmihaila added the CPS label Jun 22, 2016
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Projects
None yet
Development

No branches or pull requests

4 participants