Re: [Dhis2-devs] [Dhis2-users] Indicator totals count is incorrect

[Calle Hedberg]

Nayeem

I agree with your approach for those examples, although using the data
element aggregation type might not cater for all types of indicators (ref
for instance where numerator and denominator have different aggregation
types, or where one of them are some type of group membership count, or
indicators where you only want a result if the numerator or denominator is
above a threshold, or where one of them is offset in time). With the DHIS
increasingly used for e.g. survey data, sample data, case-based tracker
data etc etc, we need a more versatile indicator processing where all forms
of aggregation are either blocked (if clearly not correct/relevant) or else
yield correct results.

The issues have been on the agenda for a long time now, and I hope it will
be finally resolved in 2.31. What's needed is to ensure e.g. the SL demo
instance have examples of all types of indicators (and the underlying
data), then to verify that any relevant aggregation yields correct values.

Regards
Calle

On Wed, 19 Sep 2018 at 16:50, Nayeem Al Mifthah  wrote:

> Hi Calle
> Hope you doing well.
>
> You are correct in a sense of different analytics type may required for
> indicator aggregation :-)
>
> There are better and easy way to calculate. If you minutely look at my
> earlier mail, probably you identify that, I have written to perform
> aggregation according to aggregation type of the particular data element,
> which might be sum, average, average (sum in organisation unit hierarchy
> etc.). After that the indicator calculation should done.
>
> Probably my earlier mail have difficulties to understand due to only one
> example. Let me give another example as well-
>
> Probably there is a data element for number of doctors posted in an health
> facility with aggregation type average (sum in organisation unit hierarchy)
> and another data element for number of patient visited with aggregation
> type sum.
>
> Now you might have the below data table-
>
> Hospital A, January, Doctor posted- 6
> Hospital A, February, Doctor posted- 4
> Hospital A, March, Doctor posted- 6
>
> Hospital A, January, Patient visited- 3000
> Hospital A, February, Patient visited- 4000
> Hospital A, March, Patient visited- 6000
>
> Hospital B, January, Doctor posted- 40
> Hospital B, February, Doctor posted- 50
> Hospital B, March, Doctor posted- 80
>
> Hospital B, January, Patient visited- 4
> Hospital B, February, Patient visited- 3
> Hospital B, March, Patient visited- 4
>
> ___
> If you want to calculate average number of patient seen by one doctor, you
> can find-
> Hospital A in January- 500
> Hospital A in February- 1000
> Hospital A in March- 1000
>
> Now if you want to make the same indicator for first quarter there is no
> way to calculate from 500, 1000, and 1000. There average is 833 which is
> not actually expected result, even the sum 2500 is not also expected value.
>
> The best way is to make sum of patient as per the aggregation type of the
> data element which gives (3000+4000+6000)= 13000 and make average number of
> doctor posted for the period (6+4+6)/3= 5.33. Now if we done the
> calculation for the indicator we found 13000/5.33= 2439 patient has been
> seen averagely by one doctor in first quarter.
> ___
>
> Again, if you want to calculate the same indicator for-
> Hospital A in January- 500
> Hospital B in January- 1000
>
> Now, if you want to calculate for Hospital A and B together, there is no
> way to find desired value from 500 and 1000. The average is 750 and sum is
> 1500 which are not expected.
>
> The desired output should be (Patient visited hospital A in January, 3000
> + Patient visited hospital B in January, 4) / (Doctor posted in
> Hospital A, 6 + Doctor posted in hospital B, 40).
> Result 43000/46 = 934 patient per doctor.
> ___
>
> The same way of calculation is also applicable for indicators which build
> in combination of organization unit, program indicators and others.
>
> Sorry for the long mail, but hope it clarifies. :-)
>
> Regards-
> *Nayeem Al Mifthah*
> *Health Information Systems Specialist*
> Support to the National HMIS
> MIS, Directorate General of Health Services
> Ministry of Health and Family Welfare, Bangladesh
> Telephone: +880-2-58816459|Fax: +880-2-58813875
> Mobile:  +88-01914 030 574|Email: n.mift...@gmail.com
> Skype: nayeem.a.m|   LinkedIn:  linkedin.com/in/nayeemam
>
>
> On Wed, Sep 19, 2018 at 2:22 AM Calle Hedberg 
> wrote:
>
>> Folks,
>>
>> This has been repeated ad nauseam - as you say, most health indicators
>> should in general be calculated as sum(numerator)/sum(denominator), whether
>> it's aggregated in the time or in the geographic dimension. That is because
>> most aggregated data elements used to calculate indicators are counts of
>> many discrete events.
>>
>> Yes, we need some alternative processing for
>> - "number only" indicators (aka "Calcula

Re: [Dhis2-devs] Unapproved data is visible for users not assigned the "View Unapproved Data" permission

[Rajeswari Gottipati]

Hi DHIS team,

Could you please provide an update for the above reported issue.

On Wed, Sep 12, 2018 at 4:14 PM, Preeti Ajgaonkar 
wrote:

> Hi team,
>
> Recently we have been noticing that users who have not been assigned with
> the "View unapproved data" permission are able to see unapproved data in
> reporting apps i.e. Pivot tables, Data Visualizers and event reports. We
> have been seeing this since DHIS 2.27 onwards. Could you please let us know
> if this could be a bug or if there is any resolution to this?
>
> --
> Thanks
> Preeti Ajgaonkar
>



-- 
Rajeswari Gottipati
Sr Consultant
Email rajes...@thoughtworks.com
Telephone +91 9949292931 <+91%209949292931>
[image: ThoughtWorks]

___
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

Re: [Dhis2-devs] [Dhis2-users] Script to identify which war version a backup was on

[Knut Staring]

Would be nice if the different versions could be stored in the database -
perhaps with a timestamp for each time it has been restarted? I guess it is
in the log, but few people store logs along their backups.

Knut

On Thu, Sep 20, 2018 at 10:46 AM Elmarie Claasen  wrote:

> Hi all,
>
>
>
> Is there any script to use in order to identify which war version a backup
> file was last started up with? And if so from which version is this
> available?
>
>
>
> Regards,
>
>
>
> *Elmarie Claasen*
>
> [image: Hisp logo]
>
> Project Manager
>
> Health Information Systems Program
>
> Tel:  041-367 1027
>
> Cell: 082 374 2209
>
> E-mail: elma...@hisp.org
>
> Skype:  elmarie.claasen52
>
>
>
> *This message and any attachments are subject to a disclaimer published at
> http://www.hisp.org/policies.html#comms_disclaimer
> .  Please read the
> disclaimer before opening any attachment or taking any other action in
> terms of this electronic transmission.  If you cannot access the
> disclaimer, kindly send an email to disclai...@hisp.org
>  and a copy will be provided to you. By replying to
> this e-mail or opening any attachment you agree to be bound by the
> provisions of the disclaimer.*
> ___
> 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

Department of Information, Evidence and Research
World Health Organization, Geneva, Switzerland
Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar
___
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

[Dhis2-devs] Custom attribute value is downloading incorrectly in DHIS 2.29

[Rajeswari Gottipati]

Hi DHIS Team,

We were using DHIS 2.27. We have one option with name "Procedures" and its
code is "procedure". This option is assigned to one of the option set and
this set is assigned to one of the custom attribute.

We had set this custom attribute to "Procedures" for few data elements. Now
we migrated to DHIS 2.29 and created new data elements and set this custom
attribute value "Procedures".

If we query for these data elements (old and new) we are seeing different
results for this custom attribute value (code) as below

Existing Data Element:

"attributeValues": *[*

*{*

"value": "*procedures*",


"attribute": *{*

"code": "xxx",

"name": "xx",

"id": "RKB9aA9Ndg"

*}*

*}*

*]*


New Data Element:

"attributeValues": *[*

*{*

"value": "*procedure*",


"attribute": *{*

"code": "xxx",

"name": "xx",

"id": "RKB9aA9Ndg"

*}*

*}*

*]*

One more thing we observed is when we make API call for this option we are
seeing correct results as per metadata setup


{"code": "procedure","name": "Procedures","id": "bICEZ89454","translations
": []}


Could you please help us why DHIS is returning different results for same
custom attribute?

-- 
Rajeswari Gottipati
Sr Consultant
Email rajes...@thoughtworks.com
Telephone +91 9949292931 <+91%209949292931>
[image: ThoughtWorks]

___
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

[Dhis2-devs] Script to identify which war version a backup was on

[Elmarie Claasen]

Hi all,



Is there any script to use in order to identify which war version a backup
file was last started up with? And if so from which version is this
available?



Regards,



*Elmarie Claasen*

[image: Hisp logo]

Project Manager

Health Information Systems Program

Tel:  041-367 1027

Cell: 082 374 2209

E-mail: elma...@hisp.org

Skype:  elmarie.claasen52

-- 


*This message and any attachments are subject to a disclaimer published

at http://www.hisp.org/policies.html#comms_disclaimer 
. 
Please read the 
disclaimer before opening any attachment or taking any other
action in 
terms of this electronic transmission.  If you cannot access the

disclaimer, kindly send an email to disclai...@hisp.org 
 and a copy will be provided to you. By

replying to this e-mail or opening any attachment you agree to be bound by 
the
provisions of the disclaimer.*
___
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

Re: [Dhis2-devs] [Dhis2-users] Calculation indicator for some organisation unit in the formula

[Carlos Nyembwe]

Hi Lars,

I’m not sure because, yesterday I tried it only in demo but nothing.

Regards

On Wed, Sep 19, 2018 at 3:32 PM Lars Helge Øverland  wrote:

> Hi Carlos,
>
> this has now been fixed in latest build of 2.28, 2.29 and 2.30.
>
> Thanks for reporting.
>
> best,
>
> Lars
>
>
> On Wed, 19 Sep 2018 at 15:06, Stéphan Mestach 
> wrote:
>
>> Looks similar to what I've reported :
>> http://dhis-developers-list.1563109.n2.nabble.com/Indicator-that-counts-the-number-of-orgunits-within-a-group-by-region-td7613915.html
>>
>> No news since then. Currently I don't have access to the logs of the
>> dhis2 server (hosted by a third party).
>> May be a having a stacktrace might help them identify the issue.
>>
>> Stéphan
>>
>> On Wed, Sep 19, 2018 at 12:58 PM, Carlos Nyembwe 
>> wrote:
>>
> Hi dev,
>>>
>>> Since version 2.26, we have noticed in the analysis of our indicators
>>> containing the number of organizational units in the formula, and when we
>>> want to display the PivotTable by placing the organizational units either
>>> in columns or online , the process is only turning and not results, but
>>> with the previous versions, we had tables that were displayed and now they
>>> are not displayed anymore.
>>>
>>> We submitted the problem not as a result.
>>>
>>> So, how can I solve this problem?
>>>
>>> Thank you
>>>
>>> On Fri, Oct 21, 2016 at 12:44 PM Carlos Nyembwe 
>>> wrote:
>>>
 Hi everyone,

 I have a problem in my system, I need to use an indicator just for some
 organisation unit, now it's big problem in my mind, I can't to solve it.

 who can help me?

 Thanks

 --
 *Carlos Nyembwe*
 *I'm just a Computer Scientist*

 *Skype: carloscnk1*
 *Cell: (+243)813166381*
 *Find me in: | Google Plus  | 
 **Linkedin
  | Facebook
  | Twitter
  |*

>>>
>>>
>>> --
>>> *Carlos Nyembwe*
>>> *I'm just a Computer Scientist*
>>>
>>> *Skype: carloscnk1*
>>> *Cell: (+243)813166381*
>>> *Find me in: | Google Plus  | 
>>> **Linkedin
>>>  | Facebook
>>>  | Twitter
>>>  |*
>>>
>>> ___
>>> 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
>>>
>>>
>>
>>
>> --
>>
>> Stéphan Mestach
>>
>> Developer
>>
>>
>> www.bluesquarehub.com
>> [image: twitter.png]  [image: facebook.png]
>>  [image: linkedin.png]
>> 
>> ___
>> 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
>
>
>>
>
> --
> Lars Helge Øverland
> Technical lead, DHIS 2
> University of Oslo
> l...@dhis2.org
> https://www.dhis2.org
>
> --
*Carlos Nyembwe*
*I'm just a Computer Scientist*

*Skype: carloscnk1*
*Cell: (+243)813166381*
*Find me in: | Google Plus  |
**Linkedin
 | Facebook
 | Twitter
 |*
___
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