← Back to team overview

dhis2-users team mailing list archive

Re: Relative Periods in Pivot Tables & reports

 

Hello Lars,


1-      I think “months since x” will be good and more clearer since we will specify the starting date (or month) as the variable and the report will show all data from that date up until the current month (or reporting period)

2-      I don’t think “last 24 months” will be a perfect solution because there is still a probability that some projects will span more than 2 years.

So to keep it on the safe side, I think a more dynamic option will much better on the long run.

Please note that if this option can be applied to the “Quarterly” level, it will be good and usable since the only option we have for now is “last 4 quarters”. So an option like “quarters since X” will make more dynamic.


Thank you for your cooperation and for the hard work you and your team is doing.

I hope this issue can be implemented ASAP because it is really important for us.

Best Regards,

Maheed



From: Lars Helge Øverland [mailto:larshelge@xxxxxxxxx]
Sent: Friday, August 29, 2014 7:03 PM
To: Maheed Ramadan
Cc: dhis2-devs@xxxxxxxxxxxxxxxxxxx; dhis2-users; Morten Olav Hansen
Subject: Re: Relative Periods in Pivot Tables & reports


Hi Maheed,

yes I think we can improve on this.

A minor note, if you want data dynamically starting at month x, then is a relative period option "last x months" what you need to keep it dynamic? Wouldn't it rather be "months since x" ?

What if we simply made a new relative period "last 24 months", would that be good enough?

best regards,

Lars




On Fri, Aug 29, 2014 at 1:38 PM, Maheed Ramadan <maheed.ramadan@xxxxxx<mailto:maheed.ramadan@xxxxxx>> wrote:
Dear All,

As I see in pivot tables and almost all reporting modules that if we need to use relative periods, the maximum months we can view backwards is 12 Months (relative to the reporting period).

I have a requirement that I need to show monthly data for more than 12 months backwards. For example, I need to dynamically show data starting at month X year Y up till the current reporting month. Is there a possibility that we can have an option like “Last X months” and specify the value of X.?

I think this is very important feature to have because it allows us to show relative data that spans more than 12 month of time in a single report.
At our organization, we have data based on projects spanning more than a year, so if we want to show an indicator history over the time of the project, we need to show the data from the start of the project up till current month.

Awaiting your feedback.

Thank you

Maheed.



Follow ups

References