Creating indicator with non-numeric values

Support - Assistance technique
1

Hi

Is it possible to create indicator with non-numeric values in DHIS2? We have some text values (using option set) and some yes/no and some yes only values. How can I create indicator for those elements. There are some logical operation needed.

Indicator creation only done by numerical operation currently. Is it possible or in any milestone to make indicator with logical operations.

Nayeem Al Mifthah

HMIS C

onsultant

Management Information System

Directorate General of Health Services (DGHS), Bangladesh

Supported by: UNICEF
-Bangladesh

Email: n.mifthah@gmail.com*| nayeem@mis.dghs.gov.bd*

Cell:+8801914030574

2

Hi Nayeem,

at the moment it is not possible to use other data element types than numeric in indicator formulas, sorry.

Can you give us some details and context for what your are trying to achieve?

regards,

Lars

···

On Wed, Jul 23, 2014 at 11:03 AM, Nayeem Al Mifthah n.mifthah@gmail.com wrote:

Hi

Is it possible to create indicator with non-numeric values in DHIS2? We have some text values (using option set) and some yes/no and some yes only values. How can I create indicator for those elements. There are some logical operation needed.

Indicator creation only done by numerical operation currently. Is it possible or in any milestone to make indicator with logical operations.

Nayeem Al Mifthah

HMIS C

onsultant

Management Information System

Directorate General of Health Services (DGHS), Bangladesh

Supported by: UNICEF
-Bangladesh

Email: n.mifthah@gmail.com*| nayeem@mis.dghs.gov.bd*

Cell:+8801914030574

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

3

Hi,

I've got a small issue here: for a certain program and a certain orgunit, it displays the message 'There are no events" through the Event Capture module, even if I know there are as the events are still visible in the Event Reports and Manual Aggregation modules. This is only the case for this single orgunit/program combination, all others work fine.

There's no error log and clearing the cache didn't work. DHIS2.16/16253.

Any ideas?

Regards,

Robin

4

Hi,

One possibility could be blank events… have you seen details of these events in the module they have come visible?

Thank you,

Abyot.

···

On Aug 5, 2014 6:31 PM, “Robin Martens” martens@sher.be wrote:

Hi,

I’ve got a small issue here: for a certain program and a certain orgunit, it displays the message 'There are no events" through the Event Capture module, even if I know there are as the events are still visible in the Event Reports and Manual Aggregation modules. This is only the case for this single orgunit/program combination, all others work fine.

There’s no error log and clearing the cache didn’t work. DHIS2.16/16253.

Any ideas?

Regards,

Robin

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

5

Dear Lars

Thank you for feedback.

We have a half yearly facility assessment dataset. Where there are some data element for availability and ready assessment.

As Ex.-

For Labor /Delivery room we want to check, is 3 sterilized delivery set (at least) available and ready for use

The option set are-

  • Not available

  • Available but not ready for use

  • Available and ready for use

There are a number of element like this.

With an indicator we like to calculate the percentage of readiness of hospital for delivery.

···

Nayeem Al Mifthah

HMIS C

onsultant

Management Information System

Directorate General of Health Services (DGHS), Bangladesh

Supported by: UNICEF
-Bangladesh

Email: n.mifthah@gmail.com*| nayeem@mis.dghs.gov.bd*

Cell:+8801914030574

On Tue, Aug 5, 2014 at 10:21 PM, Lars Helge Øverland larshelge@gmail.com wrote:

Hi Nayeem,

at the moment it is not possible to use other data element types than numeric in indicator formulas, sorry.

Can you give us some details and context for what your are trying to achieve?

regards,

Lars

On Wed, Jul 23, 2014 at 11:03 AM, Nayeem Al Mifthah n.mifthah@gmail.com wrote:

Hi

Is it possible to create indicator with non-numeric values in DHIS2? We have some text values (using option set) and some yes/no and some yes only values. How can I create indicator for those elements. There are some logical operation needed.

Indicator creation only done by numerical operation currently. Is it possible or in any milestone to make indicator with logical operations.

Nayeem Al Mifthah

HMIS C

onsultant

Management Information System

Directorate General of Health Services (DGHS), Bangladesh

Supported by: UNICEF
-Bangladesh

Email: n.mifthah@gmail.com*| nayeem@mis.dghs.gov.bd*

Cell:+8801914030574

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

6

Hi Nayeem,
One approach if you are using aggregate data collection, would be to create three separate questions using Boolean data elements.

  1. Sterilized delivery set not available

  2. Sterilized delivery set available but not ready for use

  3. Sterilized delivery set available and ready for use

Of course, this is not ideal, because people could answer all three questions as TRUE and it is rather clunky as you would need three questions instead of one. But, you are still going to need the aggregate data elements anyway for your analysis with indicators.

If you are using the tracker for data collection, then you could implement this as an option set, and link this to respective aggregate data elements (Sterilized delivery set not available, Sterilized delivery set available but not ready for use, Sterilized delivery set available and ready for use) with the aggregation query builder on each condition . You could then create indicators such as

% of delivery sets not available = Sterilized delivery set not available/(Sterilized delivery set not available + Sterilized delivery set available but not ready for use + Sterilized delivery set available and ready for use)

Hope this helps.

Best regards,

Jason

···

On Wed, Aug 6, 2014 at 5:35 AM, Nayeem Al Mifthah n.mifthah@gmail.com wrote:

Dear Lars

Thank you for feedback.

We have a half yearly facility assessment dataset. Where there are some data element for availability and ready assessment.

As Ex.-

For Labor /Delivery room we want to check, is 3 sterilized delivery set (at least) available and ready for use

The option set are-

  • Not available
  • Available but not ready for use
  • Available and ready for use

There are a number of element like this.

With an indicator we like to calculate the percentage of readiness of hospital for delivery.

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Nayeem Al Mifthah

HMIS C

onsultant

Management Information System

Directorate General of Health Services (DGHS), Bangladesh

Supported by: UNICEF
-Bangladesh

Email: n.mifthah@gmail.com*| nayeem@mis.dghs.gov.bd*

Cell:+8801914030574

On Tue, Aug 5, 2014 at 10:21 PM, Lars Helge Øverland larshelge@gmail.com wrote:

Hi Nayeem,

at the moment it is not possible to use other data element types than numeric in indicator formulas, sorry.

Can you give us some details and context for what your are trying to achieve?

regards,

Lars

On Wed, Jul 23, 2014 at 11:03 AM, Nayeem Al Mifthah n.mifthah@gmail.com wrote:

Hi

Is it possible to create indicator with non-numeric values in DHIS2? We have some text values (using option set) and some yes/no and some yes only values. How can I create indicator for those elements. There are some logical operation needed.

Indicator creation only done by numerical operation currently. Is it possible or in any milestone to make indicator with logical operations.

Nayeem Al Mifthah

HMIS C

onsultant

Management Information System

Directorate General of Health Services (DGHS), Bangladesh

Supported by: UNICEF
-Bangladesh

Email: n.mifthah@gmail.com*| nayeem@mis.dghs.gov.bd*

Cell:+8801914030574

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

7

Hi,

I’m not sure if I understand your question, but the event report shows all the data for each of the events.

I’d like to check manually in the database to verify the entries. In which table does DHIS2 store its event data? Also, I understand that the data is moved to the analytics tables when running the analytics module, but is this a copy-paste or cut-paste of the data?

Kind regards,

Robin

···

From: Abyot Gizaw [mailto:abyota@gmail.com]

Sent: 05 August 2014 21:50

To: Robin Martens

Cc: DHIS 2 Users list

Subject: Re: [Dhis2-users] DHIS2 - Event list empty

Hi,

One possibility could be blank events… have you seen details of these events in the module they have come visible?

Thank you,

Abyot.

On Aug 5, 2014 6:31 PM, “Robin Martens” martens@sher.be wrote:

Hi,

I’ve got a small issue here: for a certain program and a certain orgunit, it displays the message 'There are no events" through the Event Capture module, even if I know there are as the events are still visible in the Event Reports and Manual Aggregation modules. This is only the case for this single orgunit/program combination, all others work fine.

There’s no error log and clearing the cache didn’t work. DHIS2.16/16253.

Any ideas?

Regards,

Robin

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

8

Hi Robin,

The event data is stored in the patientdatavalue table. You’ll see a reference to programstageinstance (event) there. Through that you can find your program, in case you have data for more than one program.

The event analytics process only reads from the patientdatavalue table, it never changes or deletes anything there.

Ola

···
  1. aug. 2014 11:51 skrev “Robin Martens” martens@sher.be følgende:

Hi,

I’m not sure if I understand your question, but the event report shows all the data for each of the events.

I’d like to check manually in the database to verify the entries. In which table does DHIS2 store its event data? Also, I understand that the data is moved to the analytics tables when running the analytics module, but is this a copy-paste or cut-paste of the data?

Kind regards,

Robin

From: Abyot Gizaw [mailto:abyota@gmail.com]

Sent: 05 August 2014 21:50

To: Robin Martens

Cc: DHIS 2 Users list

Subject: Re: [Dhis2-users] DHIS2 - Event list empty

Hi,

One possibility could be blank events… have you seen details of these events in the module they have come visible?

Thank you,

Abyot.

On Aug 5, 2014 6:31 PM, “Robin Martens” martens@sher.be wrote:

Hi,

I’ve got a small issue here: for a certain program and a certain orgunit, it displays the message 'There are no events" through the Event Capture module, even if I know there are as the events are still visible in the Event Reports and Manual Aggregation modules. This is only the case for this single orgunit/program combination, all others work fine.

There’s no error log and clearing the cache didn’t work. DHIS2.16/16253.

Any ideas?

Regards,

Robin

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@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-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

9

Small note, in 2.15 and later that table for event data records is called “trackedentitydatavalue”.

···

On Thu, Aug 7, 2014 at 8:57 AM, Ola Hodne Titlestad olati@ifi.uio.no wrote:

Hi Robin,

The event data is stored in the patientdatavalue table. You’ll see a reference to programstageinstance (event) there. Through that you can find your program, in case you have data for more than one program.

The event analytics process only reads from the patientdatavalue table, it never changes or deletes anything there.

Ola

  1. aug. 2014 11:51 skrev “Robin Martens” martens@sher.be følgende:

Hi,

I’m not sure if I understand your question, but the event report shows all the data for each of the events.

I’d like to check manually in the database to verify the entries. In which table does DHIS2 store its event data? Also, I understand that the data is moved to the analytics tables when running the analytics module, but is this a copy-paste or cut-paste of the data?

Kind regards,

Robin

From: Abyot Gizaw [mailto:abyota@gmail.com]

Sent: 05 August 2014 21:50

To: Robin Martens

Cc: DHIS 2 Users list

Subject: Re: [Dhis2-users] DHIS2 - Event list empty

Hi,

One possibility could be blank events… have you seen details of these events in the module they have come visible?

Thank you,

Abyot.

On Aug 5, 2014 6:31 PM, “Robin Martens” martens@sher.be wrote:

Hi,

I’ve got a small issue here: for a certain program and a certain orgunit, it displays the message 'There are no events" through the Event Capture module, even if I know there are as the events are still visible in the Event Reports and Manual Aggregation modules. This is only the case for this single orgunit/program combination, all others work fine.

There’s no error log and clearing the cache didn’t work. DHIS2.16/16253.

Any ideas?

Regards,

Robin

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@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-users@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-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

10

Hi,

The event report showing all your data answers my question. The analytic table does not affect your data.

The label - There are no events - comes visible only when both orgunit and program are selected, but no event is found. There is also a scenario for the same label to appear when all available events are found empty. In the earlier system it was possible to create blank event inadvertently.

Since you have seen your data in the reports module, we can rule out the case of blank events. You also said clearing the cache has no effect and there are no error logs. Can you confirm me if both orgunit and program are selected? Also do you see the button “Register event”? If so, are you able to add a new event?

Thank you,

Abyot.

···

On Wed, Aug 6, 2014 at 11:51 AM, Robin Martens martens@sher.be wrote:

Hi,

I’m not sure if I understand your question, but the event report shows all the data for each of the events.

I’d like to check manually in the database to verify the entries. In which table does DHIS2 store its event data? Also, I understand that the data is moved to the analytics tables when running the analytics module, but is this a copy-paste or cut-paste of the data?

Kind regards,

Robin

From: Abyot Gizaw [mailto:abyota@gmail.com]

Sent: 05 August 2014 21:50

To: Robin Martens

Cc: DHIS 2 Users list

Subject: Re: [Dhis2-users] DHIS2 - Event list empty

Hi,

One possibility could be blank events… have you seen details of these events in the module they have come visible?

Thank you,

Abyot.

On Aug 5, 2014 6:31 PM, “Robin Martens” martens@sher.be wrote:

Hi,

I’ve got a small issue here: for a certain program and a certain orgunit, it displays the message 'There are no events" through the Event Capture module, even if I know there are as the events are still visible in the Event Reports and Manual Aggregation modules. This is only the case for this single orgunit/program combination, all others work fine.

There’s no error log and clearing the cache didn’t work. DHIS2.16/16253.

Any ideas?

Regards,

Robin

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

11

Hi Abyot,

I can register a new event, and it’s there in the trackedentitydatavalue table, but when refreshing the page, the list is again empty with the same message (‘there are no events’). Again no error logs, and only for this orgunit/program combination (yes, they were selected).

Regards,

Robin

···

From: Abyot Gizaw [mailto:abyota@gmail.com]

Sent: 07 August 2014 10:31

To: Robin Martens

Cc: DHIS 2 Users list

Subject: Re: [Dhis2-users] DHIS2 - Event list empty

Hi,

The event report showing all your data answers my question. The analytic table does not affect your data.

The label - There are no events - comes visible only when both orgunit and program are selected, but no event is found. There is also a scenario for the same label to appear when all available events are found empty. In the earlier system it was possible to create blank event inadvertently.

Since you have seen your data in the reports module, we can rule out the case of blank events. You also said clearing the cache has no effect and there are no error logs. Can you confirm me if both orgunit and program are selected? Also do you see the button “Register event”? If so, are you able to add a new event?

Thank you,

Abyot.

On Wed, Aug 6, 2014 at 11:51 AM, Robin Martens martens@sher.be wrote:

Hi,

I’m not sure if I understand your question, but the event report shows all the data for each of the events.

I’d like to check manually in the database to verify the entries. In which table does DHIS2 store its event data? Also, I understand that the data is moved to the analytics tables when running the analytics module, but is this a copy-paste or cut-paste of the data?

Kind regards,

Robin

From: Abyot Gizaw [mailto:abyota@gmail.com]

Sent: 05 August 2014 21:50

To: Robin Martens

Cc: DHIS 2 Users list

Subject: Re: [Dhis2-users] DHIS2 - Event list empty

Hi,

One possibility could be blank events… have you seen details of these events in the module they have come visible?

Thank you,

Abyot.

On Aug 5, 2014 6:31 PM, “Robin Martens” martens@sher.be wrote:

Hi,

I’ve got a small issue here: for a certain program and a certain orgunit, it displays the message 'There are no events" through the Event Capture module, even if I know there are as the events are still visible in the Event Reports and Manual Aggregation modules. This is only the case for this single orgunit/program combination, all others work fine.

There’s no error log and clearing the cache didn’t work. DHIS2.16/16253.

Any ideas?

Regards,

Robin

Mailing list: https://launchpad.net/~dhis2-users

Post to :
dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp