Hi - I just want to echo the need of more complex logic for doing indicators.
The way that we are addressing this at PSI is by creating 'Calculated Data Elements'. That's basically a Data Element that doesn't have data entry, and instead we populate it via a SQL procedure that we run every night. A cron job currently does the job, but we are moving them into PgAgent. Our current use cases: 1. Copy the previous months 'Closing Balance' into the 'Opening Balance' of this month 2. Average distribution across the last 3 months (rather than the whole series) Another similar need that we currently plan to address via iReports is giving improvement over time: variation (increase/ decrease) - Option a: Q2 this year vs Q2 last year - Option b: This Quarter (Q2 2013) vs Previous Quarter (Q1 2013) In my mind, a potential implementation is to be able to define time ranges (default - all periods) when creating the numerator/ denominator of an indicator. R *Rodolfo Meliá* *Principal* rme...@knowming.com www.knowming.com +1 708 872 7636 +44 777 576 4090 Skype: rod.melia On Fri, Dec 6, 2013 at 7:55 AM, Ola Hodne Titlestad <ol...@ifi.uio.no>wrote: > Would be great if we could somehow combine the logic and calculations of > the surveillance rules with the analytics tables and make this data > available in the analysis tools. Sounds like a good approach to try that in > an app first. > > Ola > ------ > > ---------------------------------- > Ola Hodne Titlestad (Mr) > HISP > Department of Informatics > University of Oslo > > Mobile: +47 48069736 > Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps > link<https://maps.google.com/maps?q=Eftas%C3%A5sen+68,+0687+Oslo,+Norge&hl=en&ie=UTF8&sll=59.893855,10.785116&sspn=0.222842,0.585709&oq=eftas%C3%A5sen+68,+0687+Oslo,+&t=h&hnear=Eftas%C3%A5sen+68,+%C3%98stensj%C3%B8,+0687+Oslo,+Norway&z=16> > > > On 5 December 2013 14:53, Knut Staring <knu...@gmail.com> wrote: > >> Thanks a lot, Jim. >> >> We are in fact already developing a powerful time series app for which >> this is the main missing thing, however we may have to change to a >> different javascript graphing library (because of the license). >> >> Knut >> >> >> On Thu, Dec 5, 2013 at 12:59 PM, Jim Grace <jimgr...@gmail.com> wrote: >> >>> Hi all, >>> >>> By all means tell anyone requesting this type of analysis about the new >>> surveillance-type validation rules. They do exactly this type of analysis, >>> for example the calculation Knut mentioned, comparing this year's weekly >>> data with the average of the three previous years (e.g. week 48), >>> multiplied by 1.5. Surveillance rule features also include: >>> >>> - You can average not only just over the same period in a number of >>> previous years, but over a bounded set of weeks surrounding the week in >>> question, or a combination of both (e.g. comparing week 48 this year with >>> the average of weeks 47,48 and 49 in the previous two years, and week 47 >>> this year.) >>> >>> - You can throw out a configurable number of high and/or low outliers >>> from previous data before doing the average, so you're not comparing the >>> new data data against previous outbreaks and/or unusually low values. >>> >>> - You can analyze the data automatically as it comes in from data entry >>> each day, for any data elements (singly or in a formula) in all >>> organisation units at whatever levels you like, with customized formulas at >>> each different organizational unit level (e.g. an alarming district-wide >>> increase may be a lower percent than what could be random variation at >>> individual sites.) And be notified automatically through DHIS messaging (by >>> email if you like) of any outliers. >>> >>> If they want the data for display, this would have to be added whether >>> in the visualizer or a new app. But if they want the data for outbreak >>> detection, by all means also tell them about the new surveillance rules. >>> >>> Cheers, >>> Jim >>> >>> >>> >>> On Thu, Dec 5, 2013 at 2:17 AM, Bram Piot <bram.p...@gmail.com> wrote: >>> >>>> Hi all, >>>> >>>> Surprisingly, yesterday I had exactly the same request from one of our >>>> users in Uganda: they'd like to see monthly data for current and past year >>>> as separate lines on the same chart, very similar to Knut's example. I can >>>> imagine that this would be rather complex to handle in the visualiser - >>>> maybe this needs a separate app? >>>> >>>> bram piot >>>> >>>> >>>> >>>> On 5 December 2013 10:08, Knut Staring <knu...@gmail.com> wrote: >>>> >>>>> Thanks Ola, it's a good idea to have this also available as part of >>>>> validation rules. However, my immediate need and what organizations >>>>> dealing >>>>> with seasonal epidemics such as WHO and CDC would like to see are charts >>>>> with two lines: >>>>> >>>>> The trend of cases and deaths for the current year as compared to the >>>>> trend lines for a) the previous year or b) some kind of average for >>>>> several >>>>> previous years. See the attached example. >>>>> >>>>> Knut >>>>> >>>>> >>>>> On Thursday, December 5, 2013, Ola Hodne Titlestad wrote: >>>>> >>>>>> Knut, >>>>>> >>>>>> Your example looks more like the kind of functionality we have/could >>>>>> build into in surveillance type validation rules. >>>>>> >>>>>> Ola >>>>>> ------ >>>>>> On 4 Dec 2013 22:07, "Knut Staring" <knu...@gmail.com> wrote: >>>>>> >>>>>>> We have the same requirement, in our case to compare this year's >>>>>>> weekly data with the average of the three previous years foe the >>>>>>> corresponding periods (e.g. week 48), multiplied by 1.5. Perhaps this >>>>>>> should be available in the indicator calculation? And/or an easy way to >>>>>>> get >>>>>>> it through the api. Could you start on a Blueprint for this? >>>>>>> 4. des. 2013 20:46 skrev "Paulo Grácio" < >>>>>>> pgra...@criticalsoftware.com> følgende: >>>>>>> >>>>>>>> Hi, >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> One of the challenges that I have at the moment is the creation of >>>>>>>> an indicator based on homologous period to have evolution. Any >>>>>>>> idea/suggestion? >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> For instance get Malaria deaths for period (2013) and Malaria >>>>>>>> deaths for period-1 (2012). >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> Regards >>>>>>>> >>>>>>>> Paulo Grácio >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> _______________________________________________ >>>>>>>> Mailing list: https://launchpad.net/~dhis2-users >>>>>>>> Post to : dhis2-us...@lists.launchpad.net >>>>>>>> Unsubscribe : https://launchpad.net/~dhis2-users >>>>>>>> More help : https://help.launchpad.net/ListHelp >>>>>>>> >>>>>>>> >>>>>>> _______________________________________________ >>>>>>> Mailing list: https://launchpad.net/~dhis2-devs >>>>>>> Post to : dhis2-devs@lists.launchpad.net >>>>>>> Unsubscribe : https://launchpad.net/~dhis2-devs >>>>>>> More help : https://help.launchpad.net/ListHelp >>>>>>> >>>>>>> >>>>> >>>>> -- >>>>> Knut Staring >>>>> Dept. of Informatics, University of Oslo >>>>> +4791880522 >>>>> http://dhis2.org >>>>> >>>>> >>>>> _______________________________________________ >>>>> Mailing list: https://launchpad.net/~dhis2-users >>>>> Post to : dhis2-us...@lists.launchpad.net >>>>> Unsubscribe : https://launchpad.net/~dhis2-users >>>>> More help : https://help.launchpad.net/ListHelp >>>>> >>>>> >>>> >>>> _______________________________________________ >>>> Mailing list: https://launchpad.net/~dhis2-users >>>> Post to : dhis2-us...@lists.launchpad.net >>>> Unsubscribe : https://launchpad.net/~dhis2-users >>>> More help : https://help.launchpad.net/ListHelp >>>> >>>> >>> >> >> >> -- >> Knut Staring >> Dept. of Informatics, University of Oslo >> +4791880522 >> http://dhis2.org >> > > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-users > Post to : dhis2-us...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-users > More help : https://help.launchpad.net/ListHelp > >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp