Hi,
We have a report that requires both montly & quartery data - basically, some information (quantity of services provided) are collected monthly, while another type (quality of service) is done quarterly. On months 1 and 2, we show only the quantity of services, but every third month, we need a report showing the quantity for the current month + the quality for the quarter.
Is this possible? Showing a mix of monthly data & quarterly values? Are there any examples working that way? Does anyone have the same requirement?
Thanks,
Martin
···
**Martin Van Aken - **Freelance Enthusiast Developer
1 is monthly: put all data elements you need to collected monthly
1 is quarterly: put all data elements you need to collected quarterly
Then it would be easier for you to use analytic tools (Pivot table, Chart…). The data value in DHIS2 comes with (WHAT - data element, WHEN - period, WHERE - organisation unit), so it doesn’t matter that you can put in multiple dataSet in this case.
Hi,
We have a report that requires both montly & quartery data - basically, some information (quantity of services provided) are collected monthly, while another type (quality of service) is done quarterly. On months 1 and 2, we show only the quantity of services, but every third month, we need a report showing the quantity for the current month + the quality for the quarter.
Is this possible? Showing a mix of monthly data & quarterly values? Are there any examples working that way? Does anyone have the same requirement?
Thanks,
Martin
–
**Martin Van Aken - **Freelance Enthusiast Developer
Hi,
We have a report that requires both montly & quartery data - basically, some information (quantity of services provided) are collected monthly, while another type (quality of service) is done quarterly. On months 1 and 2, we show only the quantity of services, but every third month, we need a report showing the quantity for the current month + the quality for the quarter.
Is this possible? Showing a mix of monthly data & quarterly values? Are there any examples working that way? Does anyone have the same requirement?
Thanks,
Martin
–
**Martin Van Aken - **Freelance Enthusiast Developer
Great, thanks. I sort of tested this this afternoon in a bit trial and error mode, good to know it’s actually possible.
BTW, small point, since the report tables have been merged with the pivot table, I think part of the documentation is not more valid (ex: https://docs.dhis2.org/2.24/en/user/html/ch16s02.html). I had some trouble understanding the good layout to use in a pivot table in order to have a good structure for Jasper Studio. Some quick examples in the doc would be great, mostly to get the equivalent of the “crosstab” feature.
Martin
···
On Fri, Jun 2, 2017 at 4:12 PM, Lars Helge Øverland lars@dhis2.org wrote:
Hi Martin,
the analytics app and the API allow you retrieve months and quarters (both fixed and relative) in a single report / API call.
E.g. in pivot table, select “Last 12 months” as well as “Last 4 quarters” as load the table.
If you place the periods on columns you can easily include only the needed periods in your report design.
Hi,
We have a report that requires both montly & quartery data - basically, some information (quantity of services provided) are collected monthly, while another type (quality of service) is done quarterly. On months 1 and 2, we show only the quantity of services, but every third month, we need a report showing the quantity for the current month + the quality for the quarter.
Is this possible? Showing a mix of monthly data & quarterly values? Are there any examples working that way? Does anyone have the same requirement?
Thanks,
Martin
–
**Martin Van Aken - **Freelance Enthusiast Developer