Mix quarterly and monthly data in a (Jasper) report

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

Call me on Skype : vanakenm

Hang out with me : martin@joyouscoding.com

Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken

Company website : www.joyouscoding.com

Hi Martin,

  • 1 is monthly: put all data elements you need to collected monthly
  • 1 is quarterly: put all data elements you need to collected quarterly
    Then it would be easier for you to use analytic tools (Pivot table, Chart…). The data value in DHIS2 comes with (WHAT - data element, WHEN - period, WHERE - organisation unit), so it doesn’t matter that you can put in multiple dataSet in this case.

Some suggestion hope it can be helpful for you.

Sincerely,

···

On Fri, Jun 2, 2017 at 8:03 PM, Martin Van Aken martin@joyouscoding.com 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

Call me on Skype : vanakenm

Hang out with me : martin@joyouscoding.com

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@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Em Le Hong
DHIS2 Implementation| **HISP Vietnam **

em.hispvietnam@gmail.com | Skype: em.hispvietnam@gmail.com

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.

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@joyouscoding.com 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

Call me on Skype : vanakenm

Hang out with me : martin@joyouscoding.com

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@lists.launchpad.net

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@dhis2.org

http://www.dhis2.org

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@dhis2.org 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.

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@joyouscoding.com 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

Call me on Skype : vanakenm

Hang out with me : martin@joyouscoding.com

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@lists.launchpad.net

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@dhis2.org

http://www.dhis2.org

**Martin Van Aken - **Freelance Enthusiast Developer

Mobile : +32 486 899 652

Follow me on Twitter : @martinvanaken

Call me on Skype : vanakenm

Hang out with me : martin@joyouscoding.com

Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken

Company website : www.joyouscoding.com