a common requirement here at the West African IDSR workshop is to compare values of one data element/indicator over two time periods, typically two years as indicated in the attached example. I remember this being possible in old DHIS->Excel pivot tables when periods were split in "month" and "year", but with the "Month year" period I don't see how it can be done in the DHIS. Is there a way to do this, and if not; can it be considered as a new feature? Not sure how it could be done, but some ad-hoc creation of time series perhaps. We can always export it or make custom report, but it seems common enough for IDSR analysis to be useful on-demand inside DHIS.
Not that it helps you much, but this did indeed come up as a requirement with weekly data for Early Warning (quite similar to IDSR) in Cambodia, where I ended up making a custom app to allow comparison of this year with the average of the 3 preceding years. So this is a +1 vote for adding such functionality for all sub-annual data (though the most common use cases are probably weekly, or even daily).
···
On Thu, Apr 23, 2015 at 4:08 PM, Johan Ivar Sæbø johansa@ifi.uio.no wrote:
Hi,
a common requirement here at the West African IDSR workshop is to compare values of one data element/indicator over two time periods, typically two years as indicated in the attached example. I remember this being possible in old DHIS->Excel pivot tables when periods were split in “month” and “year”, but with the “Month year” period I don’t see how it can be done in the DHIS. Is there a way to do this, and if not; can it be considered as a new feature? Not sure how it could be done, but some ad-hoc creation of time series perhaps. We can always export it or make custom report, but it seems common enough for IDSR analysis to be useful on-demand inside DHIS.
Not that it helps you much, but this did indeed come up as a requirement with weekly data for Early Warning (quite similar to IDSR) in Cambodia, where I ended up making a custom app to allow comparison of this year with the average of the 3 preceding years. So this is a +1 vote for adding such functionality for all sub-annual data (though the most common use cases are probably weekly, or even daily).
On Thu, Apr 23, 2015 at 4:08 PM, Johan Ivar Sæbø johansa@ifi.uio.no wrote:
Hi,
a common requirement here at the West African IDSR workshop is to compare values of one data element/indicator over two time periods, typically two years as indicated in the attached example. I remember this being possible in old DHIS->Excel pivot tables when periods were split in “month” and “year”, but with the “Month year” period I don’t see how it can be done in the DHIS. Is there a way to do this, and if not; can it be considered as a new feature? Not sure how it could be done, but some ad-hoc creation of time series perhaps. We can always export it or make custom report, but it seems common enough for IDSR analysis to be useful on-demand inside DHIS.