dhis2-users team mailing list archive

[Alex Macharia <amacharia@xxxxxxxxx>]

Thanks All,

The issue is more of what Jim Grace has addressed and has pointed me to the
right direction which am embarking on trying.

The issue is to create one validation rule for the data entry checks which
would pull data from the past period (3 months) sum it and validate with
this month's data entry

Example: the entry in this month of april (e.g 10) should be less than
equal to the entry made in January(<=10).

Jim, there are different aspects of data that need to be compared
retrospectively but one scenario of  the data I have is on Linkage  for
instance, and this is on HIV health related
data from the previous HIV guidelines which focused on the linkage of
clients who tested positive and were supposed to be linked to care
immediately or within a period of three months.

I appreciate for the assistance

On Wed, Apr 11, 2018 at 9:24 PM, Jim Grace <jim@xxxxxxxxx> wrote:

> Hi Alex,
>
> At the moment the only way to compare the data between different months in
> validation rules is to use predictors -- define a predictor to pull the
> data into a different data element in the current period from the past
> period (like 3 months ago if you want -- use a predictor sequential
> sample count of 3 and a skip count of 2.) Then use a validation rule to
> compare the two data elements in the same period. For more about
> predictors, see https://docs.dhis2.org/master/en/user/html/manage_
> predictor.html
>
> The downsides of this are you have to define extra data elements and
> predictors, and run the predictors before you do the validation, and store
> extra data in the database.
>
> For the future, we are looking at possible extensions to expressions that
> would let you process past period data and current period data in the same
> expression. If you would like this to apply to validation rules, please
> submit a Jira issue to this effect, and preferably tell us more about the
> application -- like what kind of data you have and why you want to compare
> it between months. This will help us to prioritize the work if we know more
> about the use case. :) Then let me know and I will link the issue to the
> Jira Epic at https://jira.dhis2.org/browse/DHIS2-3187 where we are
> gathering these requirements.
>
> Thanks!
>
> Cheers,
> Jim
>
>
> On Wed, Apr 11, 2018 at 1:03 PM, arungatom65 <arungatom65@xxxxxxxxx>
> wrote:
>
>> That is true Mr Akumba validation rules work on defined periods
>>
>>
>>
>> Sent from my Samsung Galaxy smartphone.
>> -------- Original message --------
>> From: Barnabas Akumba <akumbabarns@xxxxxxxxx>
>> Date: 11/04/2018 19:09 (GMT+03:00)
>> To: Alex Macharia <amacharia@xxxxxxxxx>
>> Cc: dhis2-users@xxxxxxxxxxxxxxxxxxx
>> Subject: Re: [Dhis2-users] VALIDATION RULES
>>
>> Hello Alex Macharia,
>>
>> The validation rule analysis page gives you the ability to select a
>> range of dates (Start Date and End Date). This means if you want to
>> validate data for last three months, you'll have to select the First
>> date of the First Month i.e. 1st January, 2018 and Last date of March,
>> i.e. 31st March, 2018.
>> This will validate all the data that falls between the dates selected
>> and give you the corresponding output.
>>
>> I don't know if this addresses your concern?
>>
>> Regards
>>
>> On 4/11/18, Alex Macharia <amacharia@xxxxxxxxx> wrote:
>> > Hi,
>> >
>> > I there a way of creating a VALIDATION RULE that checks into other
>> periods?
>> >
>> > I wish to validate current month in reference to data entered 3 months
>> ago.
>> >
>> > Thanks
>> >
>> > --
>> > ALEX MACHARIA
>> >
>>
>>
>> --
>>
>> Barnabas AKUMBA
>>
>> *Mobile:* +2348036195778
>> *Skype:* barnabas.akumba
>>
>> _______________________________________________
>> 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
>>
>>
>
>
> --
> Jim Grace
> Core developer, DHIS 2
> HISP US Inc.
> http://www.dhis2.org <https://www.dhis2.org/>
>



-- 
ALEX MACHARIA