← Back to team overview

dhis2-users team mailing list archive

Re: [Dhis2-devs] Relative Periods in Pivot Tables & reports

 

Hi Knut,

I appreciate your feedback on this.
I guess it will make no harm to implement the quick solution by adding the 24 & 36 months options.

Also, adding more fixed options will be good, like:

1-      “last 8 quarters” & “last 16 quarters”.

2-      “last 4 six-months” & “last 6 six-months”

For now this will be fair enough but I think the dynamic solution will make it more flexible.

Regards,


Maheed Ramadan
M&E Database Officer
Norwegian Refugee Council- Lebanon

Email: maheed.ramadan@xxxxxx<mailto:maheed.ramadan@xxxxxx>
Skype: mr_maheed
Mobile: 70-888037
Website : www.nrc.no<http://www.nrc.no/>

[Description: Logo_Eng_til-epost-sign]
P Please consider the environment before printing this e-mail.
       You control Climate Change: Turn down, switch off, recycle, walk

From: Knut Staring [mailto:knutst@xxxxxxxxx]
Sent: Monday, September 01, 2014 9:58 AM
To: Maheed Ramadan
Cc: Lars Helge Øverland; dhis2-users; dhis2-devs@xxxxxxxxxxxxxxxxxxx
Subject: Re: [Dhis2-devs] Relative Periods in Pivot Tables & reports

Since you seem to need something urgently, 24 months (or even 36) would be really easy to implement - i.e. you could probably have it very quickly.

Agree with your ideal solution, though since it is is different from the current selections, it might take considerably more effort (Lars obviously knows best).

Just my 1.5 cents
Knut


On Mon, Sep 1, 2014 at 1:18 PM, Maheed Ramadan <maheed.ramadan@xxxxxx<mailto:maheed.ramadan@xxxxxx>> wrote:
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<mailto:larshelge@xxxxxxxxx>]
Sent: Friday, August 29, 2014 7:03 PM
To: Maheed Ramadan
Cc: dhis2-devs@xxxxxxxxxxxxxxxxxxx<mailto: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.



_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx<mailto:dhis2-devs@xxxxxxxxxxxxxxxxxxx>
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp



--
Knut Staring
Dept. of Informatics, University of Oslo
+4791880522
http://dhis2.org

GIF image


References