I have a data set that is collected weekly, In reports if I want monthly reports based on weekly dataset then how DHIS calculates aggregation if weeks are in between two months?
For example I have a dataset collected weekly, I want report for august month, suppose some weeks in august are like “2015-07-27 to 2015-08-02” and “2015-08-31 to 2015-09-06” (In between two different months). For these particular weeks, Does data goes into july or august or september?
I tried creating sample dataset for testing, I found that data goes into month where the week starts. That means data in this week “2015-07-27 to 2015-08-02” goes into July and “2015-08-31 to 2015-09-06” this week goes into august. Still I want to make sure that is it correct process or DHIS has different method to calculate?
you are absolutely correct. It is based on the start date of the week (or period in general).
If you want to visualize exactly how the periods and period types relate you can generate analytics and have a look in the _periodstructure database table.
I have a data set that is collected weekly, In reports if I want monthly reports based on weekly dataset then how DHIS calculates aggregation if weeks are in between two months?
For example I have a dataset collected weekly, I want report for august month, suppose some weeks in august are like “2015-07-27 to 2015-08-02” and “2015-08-31 to 2015-09-06” (In between two different months). For these particular weeks, Does data goes into july or august or september?
I tried creating sample dataset for testing, I found that data goes into month where the week starts. That means data in this week “2015-07-27 to 2015-08-02” goes into July and “2015-08-31 to 2015-09-06” this week goes into august. Still I want to make sure that is it correct process or DHIS has different method to calculate?
On Tue, Nov 24, 2015 at 11:15 PM, Lars Helge Øverland larshelge@gmail.com wrote:
Hi Hari,
you are absolutely correct. It is based on the start date of the week (or period in general).
If you want to visualize exactly how the periods and period types relate you can generate analytics and have a look in the _periodstructure database table.
I have a data set that is collected weekly, In reports if I want monthly reports based on weekly dataset then how DHIS calculates aggregation if weeks are in between two months?
For example I have a dataset collected weekly, I want report for august month, suppose some weeks in august are like “2015-07-27 to 2015-08-02” and “2015-08-31 to 2015-09-06” (In between two different months). For these particular weeks, Does data goes into july or august or september?
I tried creating sample dataset for testing, I found that data goes into month where the week starts. That means data in this week “2015-07-27 to 2015-08-02” goes into July and “2015-08-31 to 2015-09-06” this week goes into august. Still I want to make sure that is it correct process or DHIS has different method to calculate?