:58 AM
To: Maheed Ramadan
Cc: Lars Helge Øverland; dhis2-users; dhis2-devs@lists.launchpad.net
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 h
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
kn
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 perfe
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"
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 ex
We are going make an iReport from a query.
It uses data elements from the last 3 months relative to the month in
question, but we've just figured it out.
We used the period format and cast it into date in postgres. Just
substracted 3 months from this.
Thank you.
2014-04-01 10:31 GMT+02:00 Lars
Hi Kenneth,
no this is implemented in the application (java) layer. May I ask why you
need this? Did you check out the analytics web api?
http://www.dhis2.org/doc/snapshot/en/user/html/ch28s17.html
If so, is there any features you miss?
regards,
Lars
On Tue, Apr 1, 2014 at 10:27 AM, Kenneth
Hi Devs!
Is it possible to access the relative period functions in postgres?
If so, does anybody know how?
Like these ones:
LAST_MONTH, LAST_BIMONTH, LAST_QUARTER, LAST_SIX_MONTH,
MONTHS_THIS_YEAR, QUARTERS_THIS_YEAR,
___
Mailing list: https://launchp
8 matches
Mail list logo
