← Back to team overview

dhis2-users team mailing list archive

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>
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]
> *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>
> 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
> 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

Follow ups

References