dhis2-users team mailing list archive

[Lars Helge Øverland <larshelge@xxxxxxxxx>]

Isma: I think you should explore the surveillance validation feature, this
is exactly what it is designed for! Documentation
here<http://www.dhis2.org/doc/snapshot/en/user/html/ch11s05.html>,
some slides here<https://docs.google.com/presentation/d/1IqjpzdJlVEyLCaal2r0oYt0Rk3WzfOPHNW1Ozz82MCI/edit#slide=id.g172e19895_00>.
This way you can run these checks automatically, scheduled every night.
Then when violations are detected, you can send alerts through messages to
the right people. This is better from a monitoring perspective than having
to manually generate reports.

Rodolfo: Thanks for the input on the analysis use-case. It makes sense.
Would be good if you could write up the exact requirement in a blueprint.


regards,

Lars





On Sun, Dec 8, 2013 at 11:30 AM, Ismail Yusuf <ismailkoleleni@xxxxxxxxx>wrote:

> Hi,
>
> We have pretty much similar requirement with Malaria Surveillance (weekly
> reporting) here in Tanzania where by threshold calculation to detect
>  malaria outbreak is based on current reported value against three previous
> weeks values similar case like what Jim mentioned.
>
> It will be best if we could this in either analytics / indicators or
> validation rules. As a temporary fix i implemented an external script which
> reads values through API and perform some calculations. Also HMTL Standard
> report which highlight weeks exceeding set threshold value could also do :)
>
> Regards,
> Ismail
>
>
>
>
> On Fri, Dec 6, 2013 at 12:43 PM, Rodolfo Melia <rmelia@xxxxxxxxxxxx>wrote:
>
>> 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*
>> rmelia@xxxxxxxxxxxx
>> 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 <olati@xxxxxxxxxx>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 <knutst@xxxxxxxxx> 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 <jimgrace@xxxxxxxxx> 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.piot@xxxxxxxxx> 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 <knutst@xxxxxxxxx> 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" <knutst@xxxxxxxxx> 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" <
>>>>>>>>> pgracio@xxxxxxxxxxxxxxxxxxxx> 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-users@xxxxxxxxxxxxxxxxxxx
>>>>>>>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>>>>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>> _______________________________________________
>>>>>>>>> Mailing list: https://launchpad.net/~dhis2-devs
>>>>>>>>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>>>>>>>> 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-users@xxxxxxxxxxxxxxxxxxx
>>>>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>>>
>>>>>>>
>>>>>>
>>>>>> _______________________________________________
>>>>>> 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
>>>>>>
>>>>>>
>>>>>
>>>>
>>>>
>>>> --
>>>> Knut Staring
>>>> Dept. of Informatics, University of Oslo
>>>> +4791880522
>>>> http://dhis2.org
>>>>
>>>
>>>
>>> _______________________________________________
>>> 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
>>>
>>>
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Ismail Yusuf Koleleni,
> Computer Science and Engineering Department
> College of Information and Communication Technology (CoICT)
> University of Dar es Salaam
> +255713732238 / +255788732233
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>