Great, thanks. I sort of tested this this afternoon in a bit trial and error mode, good to know it's actually possible.
BTW, small point, since the report tables have been merged with the pivot table, I think part of the documentation is not more valid (ex: https://docs.dhis2.org/2.24/en/user/html/ch16s02.html). I had some trouble understanding the good layout to use in a pivot table in order to have a good structure for Jasper Studio. Some quick examples in the doc would be great, mostly to get the equivalent of the "crosstab" feature. Martin On Fri, Jun 2, 2017 at 4:12 PM, Lars Helge Øverland <[email protected]> wrote: > Hi Martin, > > the analytics app and the API allow you retrieve months and quarters (both > fixed and relative) in a single report / API call. > > E.g. in pivot table, select "Last 12 months" as well as "Last 4 quarters" > as load the table. > > If you place the periods on columns you can easily include only the needed > periods in your report design. > > > > [image: Inline image 1] > > The corresponding analytics API call: > > https://play.dhis2.org/dev/api/26/analytics.json?dimension=dx:Jtf34kNZhzP; > cYeuwXTCPkU;fbfJHSPpUQD&dimension=pe:LAST_12_MONTHS; > LAST_4_QUARTERS&filter=ou:ImspTQPwCqd > > So yes I think you can achieve this, unless I am missing something in your > question. > > regards, > > Lars > > > > > On Fri, Jun 2, 2017 at 3:03 PM, Martin Van Aken <[email protected]> > wrote: > >> Hi, >> We have a report that requires both montly & quartery data - basically, >> some information (quantity of services provided) are collected monthly, >> while another type (quality of service) is done quarterly. On months 1 and >> 2, we show only the quantity of services, but every third month, we need a >> report showing the quantity for the current month + the quality for the >> quarter. >> >> Is this possible? Showing a mix of monthly data & quarterly values? Are >> there any examples working that way? Does anyone have the same requirement? >> >> Thanks, >> >> Martin >> >> >> >> -- >> *Martin Van Aken - **Freelance Enthusiast Developer* >> >> Mobile : +32 486 899 652 >> >> Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> >> Call me on Skype : vanakenm >> Hang out with me : [email protected] >> Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken >> Company website : www.joyouscoding.com >> >> _______________________________________________ >> Mailing list: https://launchpad.net/~dhis2-users >> Post to : [email protected] >> Unsubscribe : https://launchpad.net/~dhis2-users >> More help : https://help.launchpad.net/ListHelp >> >> > > > -- > Lars Helge Øverland > Lead developer, DHIS 2 > University of Oslo > Skype: larshelgeoverland > [email protected] > http://www.dhis2.org <https://www.dhis2.org/> > > -- *Martin Van Aken - **Freelance Enthusiast Developer* Mobile : +32 486 899 652 Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> Call me on Skype : vanakenm Hang out with me : [email protected] Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken Company website : www.joyouscoding.com
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
