dhis2-devs team mailing list archive

[Rodolfo Melia <rmelia@xxxxxxxxxxxx>]

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
>
>