Re: [Dhis2-users] Mix quarterly and monthly data in a (Jasper) report

2017-06-02 Thread Martin Van Aken
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

Re: [Dhis2-users] Tie an indicator denominator to a fixed period

2017-06-02 Thread Knut Staring
No, you will have to copy the 2016 values for 2017. Can be done in sql or with a script, but since you only have 5, you might as well do it manually. On Jun 2, 2017 8:37 PM, "Dimitar Popov" wrote: > Hi Knut, > > > Thanks for the reply. That would work for 2016 for sure. > > If I want to calculat

Re: [Dhis2-users] Tie an indicator denominator to a fixed period

2017-06-02 Thread Knut Staring
I think that could make for a good JIRA issue - please go ahead. On Jun 2, 2017 8:55 PM, "Dimitar Popov" wrote: Hi Knut, OK, thanks for the time and efforts. In general it would be nice if we can use in the indicators data that is entered as attributes under each Org Unit. Since we can add a

Re: [Dhis2-users] Tie an indicator denominator to a fixed period

2017-06-02 Thread Lars Helge Øverland
Hi Georgi, try this: - collect "Number of beds" as a yearly data value. - set the aggregation type for the "Number of beds" data element to "Average (sum in org unit hierarchy". In indicators, when aggregating for a month, the analytics engine will use the "standing" value for each month based o

Re: [Dhis2-users] Tie an indicator denominator to a fixed period

2017-06-02 Thread Knut Staring
You can join a monthly numerator with an annual denominator. On Jun 2, 2017 7:06 PM, "Georgi Chakarov" wrote: Hi guys, Can someone help on this case: I need to have the Beds’ utilization rate (%) calculated for my 5 Org Units. I collect the "Number of occupied beds" as a separate data element

[Dhis2-users] Tie an indicator denominator to a fixed period

2017-06-02 Thread Georgi Chakarov
Hi guys, Can someone help on this case: I need to have the Beds' utilization rate (%) calculated for my 5 Org Units. I collect the "Number of occupied beds" as a separate data element on a monthly basis. The number of beds per Org Unit is fixed and I have collected the information for them onl

Re: [Dhis2-users] [Dhis2-devs] Potential Bug? (skip-logic rules fire on drop-down select but not on radio-button)

2017-06-02 Thread David Hagan
Thanks, Will try this out over the weekend and let you know. David On 2 June 2017 at 17:05, Markus Bekken wrote: > Hey David, > > a build is triggering now for 2.26 where this should be fixed. > > Markus > > 1. jun. 2017 kl. 14.04 skrev Markus Bekken : > > Hi there David! > I might also be a b

Re: [Dhis2-users] Mix quarterly and monthly data in a (Jasper) report

2017-06-02 Thread Lars Helge Øverland
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 th

Re: [Dhis2-users] [Dhis2-devs] Potential Bug? (skip-logic rules fire on drop-down select but not on radio-button)

2017-06-02 Thread Markus Bekken
Hey David, a build is triggering now for 2.26 where this should be fixed. Markus > 1. jun. 2017 kl. 14.04 skrev Markus Bekken : > > Hi there David! > I might also be a bit sleep deprived, but have independently confirmed what > you describe below. > > Will fix and get back to you! > > Markus

Re: [Dhis2-users] Mix quarterly and monthly data in a (Jasper) report

2017-06-02 Thread Em Le Hong
Hi Martin, >From my experience, I think you should separate it into different dataSets: - 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

Re: [Dhis2-users] Mix quarterly and monthly data in a (Jasper) report

2017-06-02 Thread Alemayehu, Sisay (CDC/CGH/DGHT)
Hi, It is not to answer the question but whoever is giving an input try to address mine also which is kind of related. I have the same requirement. Especially the monthly data are not coming from the same system. The monthly data is collected with simple spreadsheet with unique ID for the facili

[Dhis2-users] Mix quarterly and monthly data in a (Jasper) report

2017-06-02 Thread Martin Van Aken
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 r

Re: [Dhis2-users] [Dhis2-devs] dhis version 2.27 is released

2017-06-02 Thread suker wat
Very good news Le Vendredi 2 juin 2017 13h21, Calle Hedberg a écrit : Hi Good to see the team managed to get it out on time (proving that moving to a 4-month cycle was the right decision). A number of urgently needed new features are included, even if a lot of stuff recently were pus

Re: [Dhis2-users] [Dhis2-devs] dhis version 2.27 is released

2017-06-02 Thread Calle Hedberg
Hi Good to see the team managed to get it out on time (proving that moving to a 4-month cycle was the right decision). A number of urgently needed new features are included, even if a lot of stuff recently were pushed to 2.28 - I just hope the team had enough time to iron out all/most of the bugs

[Dhis2-users] dhis version 2.27 is released

2017-06-02 Thread Lars Helge Øverland
Hi all, DHIS version 2.27 is out with many new features, apps and improvements. Log in with admin/district on the demo system. ANALYTICS FEATURES --- Period and organisation unit drill-down: The Pivot Table app now supports drill-down (and up) for periods