Getting timeliness rates?

Hi,

we are working on a league table/scorecard app, and manage to get indicators and completeness rates into it. However, users also want to be able to use the timeliness rates. We don't see them in the pivot tables either, so not much help in looking at how that is done there. How can we get this information?

Johan

Hi Johan,
I don’t have a solution for you, since as you have noticed timeliness is not available through the analytics API (and thus not in pivot tables etc).

I’m not sure if the data is really available anywhere through the API, but hopefully some of the developers can answer to that. I just wanted to add that I really think adding support for timeliness in analytics is important (and it has been requested several time before). Same for exposing the raw data ("actual reports" and "expected reports"), which together with "count of datavalues" aggregation would let you do a lot of interesting completeness analysis.

Olav

···

4. nov. 2015 kl. 09.49 skrev Johan Ivar Sæbø <johansa@ifi.uio.no>:

Hi,

we are working on a league table/scorecard app, and manage to get indicators and completeness rates into it. However, users also want to be able to use the timeliness rates. We don't see them in the pivot tables either, so not much help in looking at how that is done there. How can we get this information?

Johan

_______________________________________________
Mailing list: DHIS 2 developers in Launchpad
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : DHIS 2 developers in Launchpad
More help : ListHelp - Launchpad Help

Hi All

We are relying more and more on these DQ metrics in South Africa (for providing feedback to health on policy adherence). Having access to DQ data under analytics is super important for us too! But I know this is a massive piece of work so we are waiting patiently :slight_smile:

···

On Wed, Nov 4, 2015 at 11:01 AM, Olav Poppe olav.poppe@me.com wrote:

Hi Johan,

I don’t have a solution for you, since as you have noticed timeliness is not available through the analytics API (and thus not in pivot tables etc).

I’m not sure if the data is really available anywhere through the API, but hopefully some of the developers can answer to that. I just wanted to add that I really think adding support for timeliness in analytics is important (and it has been requested several time before). Same for exposing the raw data (“actual reports” and “expected reports”), which together with “count of datavalues” aggregation would let you do a lot of interesting completeness analysis.

Olav

  1. nov. 2015 kl. 09.49 skrev Johan Ivar Sæbø johansa@ifi.uio.no:

Hi,

we are working on a league table/scorecard app, and manage to get indicators and completeness rates into it. However, users also want to be able to use the timeliness rates. We don’t see them in the pivot tables either, so not much help in looking at how that is done there. How can we get this information?

Johan


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


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

Health Information Systems Program - South Africa

**- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - **

Mobile : 073 246 2992
Landline: 021 554 3130
Fax: 086 733 8432
Skype: gregory_rowles

My +1 for this as well.

Thanks,

Ime

···

From: Dhis2-devs [mailto:dhis2-devs-bounces+imeasangansi=gmail.com@lists.launchpad.net] On Behalf Of Greg Rowles
Sent: Wednesday, November 4, 2015 9:10 AM
To: Olav Poppe
Cc: Jens Johan Kaasbøll; dhis2-devs@lists.launchpad.net
Subject: Re: [Dhis2-devs] Getting timeliness rates?

Hi All

We are relying more and more on these DQ metrics in South Africa (for providing feedback to health on policy adherence). Having access to DQ data under analytics is super important for us too! But I know this is a massive piece of work so we are waiting patiently :slight_smile:

On Wed, Nov 4, 2015 at 11:01 AM, Olav Poppe olav.poppe@me.com wrote:

Hi Johan,
I don’t have a solution for you, since as you have noticed timeliness is not available through the analytics API (and thus not in pivot tables etc).

I’m not sure if the data is really available anywhere through the API, but hopefully some of the developers can answer to that. I just wanted to add that I really think adding support for timeliness in analytics is important (and it has been requested several time before). Same for exposing the raw data (“actual reports” and “expected reports”), which together with “count of datavalues” aggregation would let you do a lot of interesting completeness analysis.

Olav

  1. nov. 2015 kl. 09.49 skrev Johan Ivar Sæbø johansa@ifi.uio.no:

Hi,

we are working on a league table/scorecard app, and manage to get indicators and completeness rates into it. However, users also want to be able to use the timeliness rates. We don’t see them in the pivot tables either, so not much help in looking at how that is done there. How can we get this information?

Johan


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


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

Health Information Systems Program - South Africa

**- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - **

Mobile : 073 246 2992
Landline: 021 554 3130

Fax: 086 733 8432

Skype: gregory_rowles

Can’t this data be exposed through a SQL View, which can be accessed through the API?

···

On Wed, Nov 4, 2015 at 11:44 AM, Ime Asangansi imeasangansi@gmail.com wrote:

My +1 for this as well.

Thanks,

Ime

From: Dhis2-devs [mailto:dhis2-devs-bounces+imeasangansi=gmail.com@lists.launchpad.net] On Behalf Of Greg Rowles
Sent: Wednesday, November 4, 2015 9:10 AM
To: Olav Poppe
Cc: Jens Johan Kaasbøll; dhis2-devs@lists.launchpad.net
Subject: Re: [Dhis2-devs] Getting timeliness rates?

Hi All

We are relying more and more on these DQ metrics in South Africa (for providing feedback to health on policy adherence). Having access to DQ data under analytics is super important for us too! But I know this is a massive piece of work so we are waiting patiently :slight_smile:

On Wed, Nov 4, 2015 at 11:01 AM, Olav Poppe olav.poppe@me.com wrote:

Hi Johan,
I don’t have a solution for you, since as you have noticed timeliness is not available through the analytics API (and thus not in pivot tables etc).

I’m not sure if the data is really available anywhere through the API, but hopefully some of the developers can answer to that. I just wanted to add that I really think adding support for timeliness in analytics is important (and it has been requested several time before). Same for exposing the raw data (“actual reports” and “expected reports”), which together with “count of datavalues” aggregation would let you do a lot of interesting completeness analysis.

Olav

  1. nov. 2015 kl. 09.49 skrev Johan Ivar Sæbø johansa@ifi.uio.no:

Hi,

we are working on a league table/scorecard app, and manage to get indicators and completeness rates into it. However, users also want to be able to use the timeliness rates. We don’t see them in the pivot tables either, so not much help in looking at how that is done there. How can we get this information?

Johan


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


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

Health Information Systems Program - South Africa

**- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - **

Mobile : 073 246 2992
Landline: 021 554 3130

Fax: 086 733 8432

Skype: gregory_rowles


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

Pierre Dane

Development Manager

Jembi Health Systems

+1

Alex

···

On Wed, Nov 4, 2015 at 12:44 PM, Ime Asangansi imeasangansi@gmail.com wrote:

My +1 for this as well.

Thanks,

Ime

From: Dhis2-devs [mailto:dhis2-devs-bounces+imeasangansi=gmail.com@lists.launchpad.net] On Behalf Of Greg Rowles
Sent: Wednesday, November 4, 2015 9:10 AM
To: Olav Poppe
Cc: Jens Johan Kaasbøll; dhis2-devs@lists.launchpad.net
Subject: Re: [Dhis2-devs] Getting timeliness rates?

Hi All

We are relying more and more on these DQ metrics in South Africa (for providing feedback to health on policy adherence). Having access to DQ data under analytics is super important for us too! But I know this is a massive piece of work so we are waiting patiently :slight_smile:

On Wed, Nov 4, 2015 at 11:01 AM, Olav Poppe olav.poppe@me.com wrote:

Hi Johan,
I don’t have a solution for you, since as you have noticed timeliness is not available through the analytics API (and thus not in pivot tables etc).

I’m not sure if the data is really available anywhere through the API, but hopefully some of the developers can answer to that. I just wanted to add that I really think adding support for timeliness in analytics is important (and it has been requested several time before). Same for exposing the raw data (“actual reports” and “expected reports”), which together with “count of datavalues” aggregation would let you do a lot of interesting completeness analysis.

Olav

  1. nov. 2015 kl. 09.49 skrev Johan Ivar Sæbø johansa@ifi.uio.no:

Hi,

we are working on a league table/scorecard app, and manage to get indicators and completeness rates into it. However, users also want to be able to use the timeliness rates. We don’t see them in the pivot tables either, so not much help in looking at how that is done there. How can we get this information?

Johan


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


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

Health Information Systems Program - South Africa

**- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - **

Mobile : 073 246 2992
Landline: 021 554 3130

Fax: 086 733 8432

Skype: gregory_rowles


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

Alex Tumwesigye

Technical Advisor - DHIS2 (Consultant),
Ministry of Health/AFENET

Kampala

Uganda

IT Consultant - BarefootPower Uganda Ltd, SmartSolar, Kenya

IT Specialist (Servers, Networks and Security, Health Information Systems - DHIS2 ) & Solar Consultant

+256 774149 775, + 256 759 800161

"I don’t want to be anything other than what I have been - one tree hill "

DQ results are calculated on request (i.e. stored temporarily only). This upgrade requires changes to the analytics engine but one way around the problem could be to create non-compulsory categorycombos for completeness + timeliness (hidden from users). Values could be pushed into the analytics tables without ever needing to store datavalues… but this would mean an additional ETL process at the end of the run-analytics process. PLUS this only addresses DQ measurements at data element level - not sure how the same could be applied at data set level…

···

On Wed, Nov 4, 2015 at 1:12 PM, Alex Tumwesigye atumwesigye@gmail.com wrote:

+1

Alex

On Wed, Nov 4, 2015 at 12:44 PM, Ime Asangansi imeasangansi@gmail.com wrote:

My +1 for this as well.

Thanks,

Ime

From: Dhis2-devs [mailto:dhis2-devs-bounces+imeasangansi=gmail.com@lists.launchpad.net] On Behalf Of Greg Rowles
Sent: Wednesday, November 4, 2015 9:10 AM
To: Olav Poppe
Cc: Jens Johan Kaasbøll; dhis2-devs@lists.launchpad.net
Subject: Re: [Dhis2-devs] Getting timeliness rates?

Hi All

We are relying more and more on these DQ metrics in South Africa (for providing feedback to health on policy adherence). Having access to DQ data under analytics is super important for us too! But I know this is a massive piece of work so we are waiting patiently :slight_smile:

On Wed, Nov 4, 2015 at 11:01 AM, Olav Poppe olav.poppe@me.com wrote:

Hi Johan,
I don’t have a solution for you, since as you have noticed timeliness is not available through the analytics API (and thus not in pivot tables etc).

I’m not sure if the data is really available anywhere through the API, but hopefully some of the developers can answer to that. I just wanted to add that I really think adding support for timeliness in analytics is important (and it has been requested several time before). Same for exposing the raw data (“actual reports” and “expected reports”), which together with “count of datavalues” aggregation would let you do a lot of interesting completeness analysis.

Olav

  1. nov. 2015 kl. 09.49 skrev Johan Ivar Sæbø johansa@ifi.uio.no:

Hi,

we are working on a league table/scorecard app, and manage to get indicators and completeness rates into it. However, users also want to be able to use the timeliness rates. We don’t see them in the pivot tables either, so not much help in looking at how that is done there. How can we get this information?

Johan


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


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

Health Information Systems Program - South Africa

**- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - **

Mobile : 073 246 2992
Landline: 021 554 3130

Fax: 086 733 8432

Skype: gregory_rowles


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

Alex Tumwesigye

Technical Advisor - DHIS2 (Consultant),
Ministry of Health/AFENET

Kampala

Uganda

IT Consultant - BarefootPower Uganda Ltd, SmartSolar, Kenya

IT Specialist (Servers, Networks and Security, Health Information Systems - DHIS2 ) & Solar Consultant

+256 774149 775, + 256 759 800161

"I don’t want to be anything other than what I have been - one tree hill "

Health Information Systems Program - South Africa

**- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - **

Mobile : 073 246 2992
Landline: 021 554 3130
Fax: 086 733 8432
Skype: gregory_rowles