dhis2-users team mailing list archive

[Martin Van Aken <martin@xxxxxxxxxxxxxxxx>]

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 <lars@xxxxxxxxx> 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 <martin@xxxxxxxxxxxxxxxx>
> 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 : martin@xxxxxxxxxxxxxxxx
>> Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken
>> Company website : www.joyouscoding.com
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>> 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
> lars@xxxxxxxxx
> 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 : martin@xxxxxxxxxxxxxxxx
Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken
Company website : www.joyouscoding.com