How can I configure an indicator that will first look at the period taken for one to access a service and then count the second visit and service and second or repeat test.
I.e I want to identify people that got tested for a soecif period of time.And one is within this group then the system will count the service as a Repeat test.
Any ideas
Stanley
Hi Stanley,
It would be great if you can give some more specifics on your use case. Which program stages do you have, and what dates/intervals are you interested in within these - or within the tracked entity attributes?
Best regards
Markus
30. mai 2017 kl. 21.37 skrev Stanley Kalyati <skalyati@gmail.com>:
How can I configure an indicator that will first look at the period taken for one to access a service and then count the second visit and service and second or repeat test.
I.e I want to identify people that got tested for a soecif period of time.And one is within this group then the system will count the service as a Repeat test.
Any ideas
Stanley
_______________________________________________
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
Markus,
Thanks for coming through.
I have a program with 3 stages.HTC,ART,Viral Load.
HTC is set for daily since clients come for testing each day.And we also do analysis with regards to those that came to access HTC services per week.Now those that turn negative are supposed to return for a retest every 3 months.So I want the system to able to identify if one was already tested like 120days ago or more than 120 days.And we call these repeat tests.
I hope this makes sense.
Secondly, if one tested negative,the two stages must be closed.Only those positive the other stages must be enabled.
I hope this makes sense.
Stanley
On May 30, 2017 10:46 PM, “Markus Bekken” markus@dhis2.org wrote:
Hi Stanley,
It would be great if you can give some more specifics on your use case. Which program stages do you have, and what dates/intervals are you interested in within these - or within the tracked entity attributes?
Best regards
Markus
- mai 2017 kl. 21.37 skrev Stanley Kalyati skalyati@gmail.com:
How can I configure an indicator that will first look at the period taken for one to access a service and then count the second visit and service and second or repeat test.
I.e I want to identify people that got tested for a soecif period of time.And one is within this group then the system will count the service as a Repeat test.
Any ideas
Stanley
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
Hey again,
Do you want to evaluate the interval between the visits in the HTC stage for negative patients, and classify them depending on wether it was more or less than 120 days since the last visit?
Or did you mean that you want to count patients currently negative, and where the last HTC visit happened more than 120 days ago? (Patients that should have come in for a repeat test)
Best
Markus
I hope this makes sense.
Secondly, if one tested negative,the two stages must be closed.Only those positive the other stages must be enabled.
I hope this makes sense.
Stanley
On May 30, 2017 10:46 PM, “Markus Bekken” markus@dhis2.org wrote:
Hi Stanley,
It would be great if you can give some more specifics on your use case. Which program stages do you have, and what dates/intervals are you interested in within these - or within the tracked entity attributes?
Best regards
Markus
- mai 2017 kl. 21.37 skrev Stanley Kalyati skalyati@gmail.com:
How can I configure an indicator that will first look at the period taken for one to access a service and then count the second visit and service and second or repeat test.
I.e I want to identify people that got tested for a soecif period of time.And one is within this group then the system will count the service as a Repeat test.
Any ideas
Stanley
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
Markus,
You have just hit the nail on the head.All those conditions are what am looking for.
Please guide.
Thanks
Stanley
On May 31, 2017 9:50 AM, “Markus Bekken” markus@dhis2.org wrote:
Hey again,
Do you want to evaluate the interval between the visits in the HTC stage for negative patients, and classify them depending on wether it was more or less than 120 days since the last visit?
Or did you mean that you want to count patients currently negative, and where the last HTC visit happened more than 120 days ago? (Patients that should have come in for a repeat test)
Best
Markus
- mai 2017 kl. 06.54 skrev Stanley Kalyati skalyati@gmail.com:
Markus,
Thanks for coming through.
I have a program with 3 stages.HTC,ART,Viral Load.
HTC is set for daily since clients come for testing each day.And we also do analysis with regards to those that came to access HTC services per week.Now those that turn negative are supposed to return for a retest every 3 months.So I want the system to able to identify if one was already tested like 120days ago or more than 120 days.And we call these repeat tests.
I hope this makes sense.
Secondly, if one tested negative,the two stages must be closed.Only those positive the other stages must be enabled.
I hope this makes sense.
Stanley
On May 30, 2017 10:46 PM, “Markus Bekken” markus@dhis2.org wrote:
Hi Stanley,
It would be great if you can give some more specifics on your use case. Which program stages do you have, and what dates/intervals are you interested in within these - or within the tracked entity attributes?
Best regards
Markus
- mai 2017 kl. 21.37 skrev Stanley Kalyati skalyati@gmail.com:
How can I configure an indicator that will first look at the period taken for one to access a service and then count the second visit and service and second or repeat test.
I.e I want to identify people that got tested for a soecif period of time.And one is within this group then the system will count the service as a Repeat test.
Any ideas
Stanley
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
Hi Markus,
Stanley, I hope I am not hijacking the conversation.
Is it possible to just count that some one received the HTC services in a given period and not how many times they received this service.
Like Stanley said, this is a service offered on a daily/weekly basis and in order to avoid double counting I would just want to check if service is provided in a given period despite the number of times.
How do I accomplish this?
On Wed, May 31, 2017 at 12:54 PM, Stanley Kalyati skalyati@gmail.com wrote:
Markus,
You have just hit the nail on the head.All those conditions are what am looking for.
Please guide.
Thanks
Stanley
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
Thank you and Kind Regards
*Immarcqulate. A (Emma Kassy) *
“You miss 100% of the shots you don’t take.”
On May 31, 2017 9:50 AM, “Markus Bekken” markus@dhis2.org wrote:
Hey again,
Do you want to evaluate the interval between the visits in the HTC stage for negative patients, and classify them depending on wether it was more or less than 120 days since the last visit?
Or did you mean that you want to count patients currently negative, and where the last HTC visit happened more than 120 days ago? (Patients that should have come in for a repeat test)
Best
Markus
- mai 2017 kl. 06.54 skrev Stanley Kalyati skalyati@gmail.com:
Markus,
Thanks for coming through.
I have a program with 3 stages.HTC,ART,Viral Load.
HTC is set for daily since clients come for testing each day.And we also do analysis with regards to those that came to access HTC services per week.Now those that turn negative are supposed to return for a retest every 3 months.So I want the system to able to identify if one was already tested like 120days ago or more than 120 days.And we call these repeat tests.
I hope this makes sense.
Secondly, if one tested negative,the two stages must be closed.Only those positive the other stages must be enabled.
I hope this makes sense.
Stanley
On May 30, 2017 10:46 PM, “Markus Bekken” markus@dhis2.org wrote:
Hi Stanley,
It would be great if you can give some more specifics on your use case. Which program stages do you have, and what dates/intervals are you interested in within these - or within the tracked entity attributes?
Best regards
Markus
- mai 2017 kl. 21.37 skrev Stanley Kalyati skalyati@gmail.com:
How can I configure an indicator that will first look at the period taken for one to access a service and then count the second visit and service and second or repeat test.
I.e I want to identify people that got tested for a soecif period of time.And one is within this group then the system will count the service as a Repeat test.
Any ideas
Stanley
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
This another good observation.Let me also benefit from this.
Stanley
On Wed, May 31, 2017 at 1:26 PM, Immaculate Ayebazibwe ekassy29@gmail.com wrote:
Hi Markus,
Stanley, I hope I am not hijacking the conversation.
Is it possible to just count that some one received the HTC services in a given period and not how many times they received this service.
Like Stanley said, this is a service offered on a daily/weekly basis and in order to avoid double counting I would just want to check if service is provided in a given period despite the number of times.
How do I accomplish this?
Thank you and Kind Regards
*Immarcqulate. A (Emma Kassy) *
“You miss 100% of the shots you don’t take.”
On Wed, May 31, 2017 at 12:54 PM, Stanley Kalyati skalyati@gmail.com wrote:
Markus,
You have just hit the nail on the head.All those conditions are what am looking for.
Please guide.
Thanks
Stanley
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
On May 31, 2017 9:50 AM, “Markus Bekken” markus@dhis2.org wrote:
Hey again,
Do you want to evaluate the interval between the visits in the HTC stage for negative patients, and classify them depending on wether it was more or less than 120 days since the last visit?
Or did you mean that you want to count patients currently negative, and where the last HTC visit happened more than 120 days ago? (Patients that should have come in for a repeat test)
Best
Markus
- mai 2017 kl. 06.54 skrev Stanley Kalyati skalyati@gmail.com:
Markus,
Thanks for coming through.
I have a program with 3 stages.HTC,ART,Viral Load.
HTC is set for daily since clients come for testing each day.And we also do analysis with regards to those that came to access HTC services per week.Now those that turn negative are supposed to return for a retest every 3 months.So I want the system to able to identify if one was already tested like 120days ago or more than 120 days.And we call these repeat tests.
I hope this makes sense.
Secondly, if one tested negative,the two stages must be closed.Only those positive the other stages must be enabled.
I hope this makes sense.
Stanley
On May 30, 2017 10:46 PM, “Markus Bekken” markus@dhis2.org wrote:
Hi Stanley,
It would be great if you can give some more specifics on your use case. Which program stages do you have, and what dates/intervals are you interested in within these - or within the tracked entity attributes?
Best regards
Markus
- mai 2017 kl. 21.37 skrev Stanley Kalyati skalyati@gmail.com:
How can I configure an indicator that will first look at the period taken for one to access a service and then count the second visit and service and second or repeat test.
I.e I want to identify people that got tested for a soecif period of time.And one is within this group then the system will count the service as a Repeat test.
Any ideas
Stanley
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
Any update on this?
Eagerly waiting for ideas.
Stanley
On Wed, May 31, 2017 at 2:08 PM, Stanley Kalyati skalyati@gmail.com wrote:
Stanley
This another good observation.Let me also benefit from this.
On Wed, May 31, 2017 at 1:26 PM, Immaculate Ayebazibwe ekassy29@gmail.com wrote:
Hi Markus,
Stanley, I hope I am not hijacking the conversation.
Is it possible to just count that some one received the HTC services in a given period and not how many times they received this service.
Like Stanley said, this is a service offered on a daily/weekly basis and in order to avoid double counting I would just want to check if service is provided in a given period despite the number of times.
How do I accomplish this?
Thank you and Kind Regards
*Immarcqulate. A (Emma Kassy) *
“You miss 100% of the shots you don’t take.”
On Wed, May 31, 2017 at 12:54 PM, Stanley Kalyati skalyati@gmail.com wrote:
Markus,
You have just hit the nail on the head.All those conditions are what am looking for.
Please guide.
Thanks
Stanley
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
On May 31, 2017 9:50 AM, “Markus Bekken” markus@dhis2.org wrote:
Hey again,
Do you want to evaluate the interval between the visits in the HTC stage for negative patients, and classify them depending on wether it was more or less than 120 days since the last visit?
Or did you mean that you want to count patients currently negative, and where the last HTC visit happened more than 120 days ago? (Patients that should have come in for a repeat test)
Best
Markus
- mai 2017 kl. 06.54 skrev Stanley Kalyati skalyati@gmail.com:
Markus,
Thanks for coming through.
I have a program with 3 stages.HTC,ART,Viral Load.
HTC is set for daily since clients come for testing each day.And we also do analysis with regards to those that came to access HTC services per week.Now those that turn negative are supposed to return for a retest every 3 months.So I want the system to able to identify if one was already tested like 120days ago or more than 120 days.And we call these repeat tests.
I hope this makes sense.
Secondly, if one tested negative,the two stages must be closed.Only those positive the other stages must be enabled.
I hope this makes sense.
Stanley
On May 30, 2017 10:46 PM, “Markus Bekken” markus@dhis2.org wrote:
Hi Stanley,
It would be great if you can give some more specifics on your use case. Which program stages do you have, and what dates/intervals are you interested in within these - or within the tracked entity attributes?
Best regards
Markus
- mai 2017 kl. 21.37 skrev Stanley Kalyati skalyati@gmail.com:
How can I configure an indicator that will first look at the period taken for one to access a service and then count the second visit and service and second or repeat test.
I.e I want to identify people that got tested for a soecif period of time.And one is within this group then the system will count the service as a Repeat test.
Any ideas
Stanley
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
Hi there Stanley and Emma,
sorry for the delay.
For Emmas Question - To count wether someone has received services or not - but avoid counting them twice - you can make the following indicator:
Analytic type: Event
Aggregation operator: Count
Expression: V{tei_count}
Filter: V{program_stage_uid} == ‘THE UID OF YOUR SERVICE PROGRAM STAGE’
(if you are using 2.25 or older, the last filter is not possible - you would have to make a filter checking one of the mandatory data elements in your program stage(s) used for giving services)
For the original two issues from Stanley:
The interval between two events of the same stage is not currently possible to calculate with the current program indicator functionality. We hope to make full support for this in a coming release. To work around this in the current solution, you would have to register the interval since the last event as a data element in the repeating program stage. This data element could be something that the data entry user calculates and enters, or it could be auto assigned by a program rule. The vulnerability with using a helper data element would be the fact that the interval is a part of the data, and if you already have data entered these older events would not have the correct value in this data element. If you change your mind or there is an error in the data, it would be manual work to go through and rectify them.
Finding all patients that is negative and with more than 120 days since the last service can be done in 2.26 and later with the following program indicator:
Analytic type: Enrollment
Aggreagation operator: Count
Expression: V{tei_count}
Filter: #{DATA ELEMENT FOR DIAGNOSIS} == ‘Negative’ and d2:daysBetween(V{event_date}, V{current_date}) > 120
Hope this helps.
Best regards
Markus
On Wed, May 31, 2017 at 2:08 PM, Stanley Kalyati skalyati@gmail.com wrote:
Stanley
This another good observation.Let me also benefit from this.
On Wed, May 31, 2017 at 1:26 PM, Immaculate Ayebazibwe ekassy29@gmail.com wrote:
Hi Markus,
Stanley, I hope I am not hijacking the conversation.
Is it possible to just count that some one received the HTC services in a given period and not how many times they received this service.
Like Stanley said, this is a service offered on a daily/weekly basis and in order to avoid double counting I would just want to check if service is provided in a given period despite the number of times.
How do I accomplish this?
Thank you and Kind Regards
*Immarcqulate. A (Emma Kassy) *
“You miss 100% of the shots you don’t take.”
On Wed, May 31, 2017 at 12:54 PM, Stanley Kalyati skalyati@gmail.com wrote:
Markus,
You have just hit the nail on the head.All those conditions are what am looking for.
Please guide.
Thanks
Stanley
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
On May 31, 2017 9:50 AM, “Markus Bekken” markus@dhis2.org wrote:
Hey again,
Do you want to evaluate the interval between the visits in the HTC stage for negative patients, and classify them depending on wether it was more or less than 120 days since the last visit?
Or did you mean that you want to count patients currently negative, and where the last HTC visit happened more than 120 days ago? (Patients that should have come in for a repeat test)
Best
Markus
- mai 2017 kl. 06.54 skrev Stanley Kalyati skalyati@gmail.com:
Markus,
Thanks for coming through.
I have a program with 3 stages.HTC,ART,Viral Load.
HTC is set for daily since clients come for testing each day.And we also do analysis with regards to those that came to access HTC services per week.Now those that turn negative are supposed to return for a retest every 3 months.So I want the system to able to identify if one was already tested like 120days ago or more than 120 days.And we call these repeat tests.
I hope this makes sense.
Secondly, if one tested negative,the two stages must be closed.Only those positive the other stages must be enabled.
I hope this makes sense.
Stanley
On May 30, 2017 10:46 PM, “Markus Bekken” markus@dhis2.org wrote:
Hi Stanley,
It would be great if you can give some more specifics on your use case. Which program stages do you have, and what dates/intervals are you interested in within these - or within the tracked entity attributes?
Best regards
Markus
- mai 2017 kl. 21.37 skrev Stanley Kalyati skalyati@gmail.com:
How can I configure an indicator that will first look at the period taken for one to access a service and then count the second visit and service and second or repeat test.
I.e I want to identify people that got tested for a soecif period of time.And one is within this group then the system will count the service as a Repeat test.
Any ideas
Stanley
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
Thank you Markus,
Will get back to you.
On Thu, Jun 1, 2017 at 1:04 PM, Markus Bekken markus@dhis2.org wrote:
Hi there Stanley and Emma,
sorry for the delay.
For Emmas Question - To count wether someone has received services or not - but avoid counting them twice - you can make the following indicator:
Analytic type: Event
Aggregation operator: Count
Expression: V{tei_count}
Filter: V{program_stage_uid} == ‘THE UID OF YOUR SERVICE PROGRAM STAGE’
(if you are using 2.25 or older, the last filter is not possible - you would have to make a filter checking one of the mandatory data elements in your program stage(s) used for giving services)
For the original two issues from Stanley:
The interval between two events of the same stage is not currently possible to calculate with the current program indicator functionality. We hope to make full support for this in a coming release. To work around this in the current solution, you would have to register the interval since the last event as a data element in the repeating program stage. This data element could be something that the data entry user calculates and enters, or it could be auto assigned by a program rule. The vulnerability with using a helper data element would be the fact that the interval is a part of the data, and if you already have data entered these older events would not have the correct value in this data element. If you change your mind or there is an error in the data, it would be manual work to go through and rectify them.
Finding all patients that is negative and with more than 120 days since the last service can be done in 2.26 and later with the following program indicator:
Analytic type: Enrollment
Aggreagation operator: Count
Expression: V{tei_count}
Filter: #{DATA ELEMENT FOR DIAGNOSIS} == ‘Negative’ and d2:daysBetween(V{event_date}, V{current_date}) > 120
Hope this helps.
Best regards
Markus
- jun. 2017 kl. 09.43 skrev Stanley Kalyati skalyati@gmail.com:
Any update on this?
Eagerly waiting for ideas.
Stanley
Thank you and Kind Regards
*Immarcqulate. A (Emma Kassy) *
“You miss 100% of the shots you don’t take.”
On Wed, May 31, 2017 at 2:08 PM, Stanley Kalyati skalyati@gmail.com wrote:
Stanley
This another good observation.Let me also benefit from this.
On Wed, May 31, 2017 at 1:26 PM, Immaculate Ayebazibwe ekassy29@gmail.com wrote:
Hi Markus,
Stanley, I hope I am not hijacking the conversation.
Is it possible to just count that some one received the HTC services in a given period and not how many times they received this service.
Like Stanley said, this is a service offered on a daily/weekly basis and in order to avoid double counting I would just want to check if service is provided in a given period despite the number of times.
How do I accomplish this?
Thank you and Kind Regards
*Immarcqulate. A (Emma Kassy) *
“You miss 100% of the shots you don’t take.”
On Wed, May 31, 2017 at 12:54 PM, Stanley Kalyati skalyati@gmail.com wrote:
Markus,
You have just hit the nail on the head.All those conditions are what am looking for.
Please guide.
Thanks
Stanley
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
On May 31, 2017 9:50 AM, “Markus Bekken” markus@dhis2.org wrote:
Hey again,
Do you want to evaluate the interval between the visits in the HTC stage for negative patients, and classify them depending on wether it was more or less than 120 days since the last visit?
Or did you mean that you want to count patients currently negative, and where the last HTC visit happened more than 120 days ago? (Patients that should have come in for a repeat test)
Best
Markus
- mai 2017 kl. 06.54 skrev Stanley Kalyati skalyati@gmail.com:
Markus,
Thanks for coming through.
I have a program with 3 stages.HTC,ART,Viral Load.
HTC is set for daily since clients come for testing each day.And we also do analysis with regards to those that came to access HTC services per week.Now those that turn negative are supposed to return for a retest every 3 months.So I want the system to able to identify if one was already tested like 120days ago or more than 120 days.And we call these repeat tests.
I hope this makes sense.
Secondly, if one tested negative,the two stages must be closed.Only those positive the other stages must be enabled.
I hope this makes sense.
Stanley
On May 30, 2017 10:46 PM, “Markus Bekken” markus@dhis2.org wrote:
Hi Stanley,
It would be great if you can give some more specifics on your use case. Which program stages do you have, and what dates/intervals are you interested in within these - or within the tracked entity attributes?
Best regards
Markus
- mai 2017 kl. 21.37 skrev Stanley Kalyati skalyati@gmail.com:
How can I configure an indicator that will first look at the period taken for one to access a service and then count the second visit and service and second or repeat test.
I.e I want to identify people that got tested for a soecif period of time.And one is within this group then the system will count the service as a Repeat test.
Any ideas
Stanley
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
Hi Markus and All
thank you for your help with regards to program indicators evaluation between period.i.e
Finding all patients that is negative and with more than 120 days since the last service can be done in 2.26 and later with the following program indicator:
Analytic type: Enrollment
Aggreagation operator: Count
Expression: V{tei_count}
Filter: #{DATA ELEMENT FOR DIAGNOSIS} == ‘Negative’ and d2:daysBetween(V{event_date}, V{current_date}) > 120
However,how can i evaluate or add a condition of all those tested “negative” 120 days ago but have tested "positive’’ within 120 days after the first HIV test?
Will it look like this?
Analytic type: Enrollment
Aggreagation operator: Count
Expression: V{tei_count}
Filter: (#{DATA ELEMENT FOR DIAGNOSIS} == ‘Negative’ and d2:daysBetween(V{event_date}, V{current_date}) > 120) and (#{DATA ELEMENT FOR DIAGNOSIS} == ‘Positive’ and d2:daysBetween(V{event_date}, V{current_date})<120)
Kindly assist
Stanley
On Fri, Jun 2, 2017 at 8:14 AM, Immaculate Ayebazibwe ekassy29@gmail.com wrote:
Thank you Markus,
Will get back to you.
Thank you and Kind Regards
*Immarcqulate. A (Emma Kassy) *
“You miss 100% of the shots you don’t take.”
On Thu, Jun 1, 2017 at 1:04 PM, Markus Bekken markus@dhis2.org wrote:
Hi there Stanley and Emma,
sorry for the delay.
For Emmas Question - To count wether someone has received services or not - but avoid counting them twice - you can make the following indicator:
Analytic type: Event
Aggregation operator: Count
Expression: V{tei_count}
Filter: V{program_stage_uid} == ‘THE UID OF YOUR SERVICE PROGRAM STAGE’
(if you are using 2.25 or older, the last filter is not possible - you would have to make a filter checking one of the mandatory data elements in your program stage(s) used for giving services)
For the original two issues from Stanley:
The interval between two events of the same stage is not currently possible to calculate with the current program indicator functionality. We hope to make full support for this in a coming release. To work around this in the current solution, you would have to register the interval since the last event as a data element in the repeating program stage. This data element could be something that the data entry user calculates and enters, or it could be auto assigned by a program rule. The vulnerability with using a helper data element would be the fact that the interval is a part of the data, and if you already have data entered these older events would not have the correct value in this data element. If you change your mind or there is an error in the data, it would be manual work to go through and rectify them.
Finding all patients that is negative and with more than 120 days since the last service can be done in 2.26 and later with the following program indicator:
Analytic type: Enrollment
Aggreagation operator: Count
Expression: V{tei_count}
Filter: #{DATA ELEMENT FOR DIAGNOSIS} == ‘Negative’ and d2:daysBetween(V{event_date}, V{current_date}) > 120
Hope this helps.
Best regards
Markus
- jun. 2017 kl. 09.43 skrev Stanley Kalyati skalyati@gmail.com:
Any update on this?
Eagerly waiting for ideas.
Stanley
On Wed, May 31, 2017 at 2:08 PM, Stanley Kalyati skalyati@gmail.com wrote:
Stanley
This another good observation.Let me also benefit from this.
On Wed, May 31, 2017 at 1:26 PM, Immaculate Ayebazibwe ekassy29@gmail.com wrote:
Hi Markus,
Stanley, I hope I am not hijacking the conversation.
Is it possible to just count that some one received the HTC services in a given period and not how many times they received this service.
Like Stanley said, this is a service offered on a daily/weekly basis and in order to avoid double counting I would just want to check if service is provided in a given period despite the number of times.
How do I accomplish this?
Thank you and Kind Regards
*Immarcqulate. A (Emma Kassy) *
“You miss 100% of the shots you don’t take.”
On Wed, May 31, 2017 at 12:54 PM, Stanley Kalyati skalyati@gmail.com wrote:
Markus,
You have just hit the nail on the head.All those conditions are what am looking for.
Please guide.
Thanks
Stanley
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
On May 31, 2017 9:50 AM, “Markus Bekken” markus@dhis2.org wrote:
Hey again,
Do you want to evaluate the interval between the visits in the HTC stage for negative patients, and classify them depending on wether it was more or less than 120 days since the last visit?
Or did you mean that you want to count patients currently negative, and where the last HTC visit happened more than 120 days ago? (Patients that should have come in for a repeat test)
Best
Markus
- mai 2017 kl. 06.54 skrev Stanley Kalyati skalyati@gmail.com:
Markus,
Thanks for coming through.
I have a program with 3 stages.HTC,ART,Viral Load.
HTC is set for daily since clients come for testing each day.And we also do analysis with regards to those that came to access HTC services per week.Now those that turn negative are supposed to return for a retest every 3 months.So I want the system to able to identify if one was already tested like 120days ago or more than 120 days.And we call these repeat tests.
I hope this makes sense.
Secondly, if one tested negative,the two stages must be closed.Only those positive the other stages must be enabled.
I hope this makes sense.
Stanley
On May 30, 2017 10:46 PM, “Markus Bekken” markus@dhis2.org wrote:
Hi Stanley,
It would be great if you can give some more specifics on your use case. Which program stages do you have, and what dates/intervals are you interested in within these - or within the tracked entity attributes?
Best regards
Markus
- mai 2017 kl. 21.37 skrev Stanley Kalyati skalyati@gmail.com:
How can I configure an indicator that will first look at the period taken for one to access a service and then count the second visit and service and second or repeat test.
I.e I want to identify people that got tested for a soecif period of time.And one is within this group then the system will count the service as a Repeat test.
Any ideas
Stanley
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
Hey Stanley,
currently thats not possible to do exactly as defined below. When using the enrollment analytics type, the repeated events is “flattened”, so you can only query the newest data value for each data element within each program stage. You would have to model your data for the purpose if you want to do something like this. For example by splitting into more program stages or by having certain data elements that gets filled in at patient status changes.
We are looking at ways to avoid this flattening and letting you query in the way you want here, but it is not tagged to a release yet.
Markus
On Fri, Jun 2, 2017 at 8:14 AM, Immaculate Ayebazibwe ekassy29@gmail.com wrote:
Thank you Markus,
Will get back to you.
Thank you and Kind Regards
*Immarcqulate. A (Emma Kassy) *
“You miss 100% of the shots you don’t take.”
On Thu, Jun 1, 2017 at 1:04 PM, Markus Bekken markus@dhis2.org wrote:
Hi there Stanley and Emma,
sorry for the delay.
For Emmas Question - To count wether someone has received services or not - but avoid counting them twice - you can make the following indicator:
Analytic type: Event
Aggregation operator: Count
Expression: V{tei_count}
Filter: V{program_stage_uid} == ‘THE UID OF YOUR SERVICE PROGRAM STAGE’
(if you are using 2.25 or older, the last filter is not possible - you would have to make a filter checking one of the mandatory data elements in your program stage(s) used for giving services)
For the original two issues from Stanley:
The interval between two events of the same stage is not currently possible to calculate with the current program indicator functionality. We hope to make full support for this in a coming release. To work around this in the current solution, you would have to register the interval since the last event as a data element in the repeating program stage. This data element could be something that the data entry user calculates and enters, or it could be auto assigned by a program rule. The vulnerability with using a helper data element would be the fact that the interval is a part of the data, and if you already have data entered these older events would not have the correct value in this data element. If you change your mind or there is an error in the data, it would be manual work to go through and rectify them.
Finding all patients that is negative and with more than 120 days since the last service can be done in 2.26 and later with the following program indicator:
Analytic type: Enrollment
Aggreagation operator: Count
Expression: V{tei_count}
Filter: #{DATA ELEMENT FOR DIAGNOSIS} == ‘Negative’ and d2:daysBetween(V{event_date}, V{current_date}) > 120
Hope this helps.
Best regards
Markus
- jun. 2017 kl. 09.43 skrev Stanley Kalyati skalyati@gmail.com:
Any update on this?
Eagerly waiting for ideas.
Stanley
On Wed, May 31, 2017 at 2:08 PM, Stanley Kalyati skalyati@gmail.com wrote:
Stanley
This another good observation.Let me also benefit from this.
On Wed, May 31, 2017 at 1:26 PM, Immaculate Ayebazibwe ekassy29@gmail.com wrote:
Hi Markus,
Stanley, I hope I am not hijacking the conversation.
Is it possible to just count that some one received the HTC services in a given period and not how many times they received this service.
Like Stanley said, this is a service offered on a daily/weekly basis and in order to avoid double counting I would just want to check if service is provided in a given period despite the number of times.
How do I accomplish this?
Thank you and Kind Regards
*Immarcqulate. A (Emma Kassy) *
“You miss 100% of the shots you don’t take.”
On Wed, May 31, 2017 at 12:54 PM, Stanley Kalyati skalyati@gmail.com wrote:
Markus,
You have just hit the nail on the head.All those conditions are what am looking for.
Please guide.
Thanks
Stanley
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
On May 31, 2017 9:50 AM, “Markus Bekken” markus@dhis2.org wrote:
Hey again,
Do you want to evaluate the interval between the visits in the HTC stage for negative patients, and classify them depending on wether it was more or less than 120 days since the last visit?
Or did you mean that you want to count patients currently negative, and where the last HTC visit happened more than 120 days ago? (Patients that should have come in for a repeat test)
Best
Markus
- mai 2017 kl. 06.54 skrev Stanley Kalyati skalyati@gmail.com:
Markus,
Thanks for coming through.
I have a program with 3 stages.HTC,ART,Viral Load.
HTC is set for daily since clients come for testing each day.And we also do analysis with regards to those that came to access HTC services per week.Now those that turn negative are supposed to return for a retest every 3 months.So I want the system to able to identify if one was already tested like 120days ago or more than 120 days.And we call these repeat tests.
I hope this makes sense.
Secondly, if one tested negative,the two stages must be closed.Only those positive the other stages must be enabled.
I hope this makes sense.
Stanley
On May 30, 2017 10:46 PM, “Markus Bekken” markus@dhis2.org wrote:
Hi Stanley,
It would be great if you can give some more specifics on your use case. Which program stages do you have, and what dates/intervals are you interested in within these - or within the tracked entity attributes?
Best regards
Markus
- mai 2017 kl. 21.37 skrev Stanley Kalyati skalyati@gmail.com:
How can I configure an indicator that will first look at the period taken for one to access a service and then count the second visit and service and second or repeat test.
I.e I want to identify people that got tested for a soecif period of time.And one is within this group then the system will count the service as a Repeat test.
Any ideas
Stanley
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