Hello again I have another two questions about how to set up program indicators that make a calculation across multiple stages.
In our use case, we have two ‘status’ data elements with coded option sets (one in the first stage when a patient enters the program and the second in the second stage when the patient exits the program). We would like to calculate a count of patients by status (either using the second stage dE result or the first stage dE result if the second stage status is null.
We were able to set this up by using two PI and then aggregating the PI in an indicator. The first PI counted the patients by status in the second stage. The second PI counted patients by status in the first stage if the second stage was null. Both PI used V{enrollment_count} and aggregated to the same custom date using custom boundaries.
Is it possible to set this calculation up as a single PI?
Additionally, when using V{enrollment_count} in the expression, is it possible to prevent zeros from populating in pivot tables, when the filter conditions are not met?
Wow! Thanks @Markus. Previously we had just left the filter blank, but the zeros disappear when adding a filter for if any of the data elements mentioned in the d2:condition equal the option we are trying to count.
Hello all! A few questions/recommendations here (most of which I have posted in JIRA some time ago):
d2:round, d2:ceil and d2:floor functions do not work with mathematical expressions. I cannot create an experssion like this: d2:round(DataElement1/DataElement2,0). The functions only work with one data element at a time. This caused me a lot of trouble for a project and we actually built a custom app to bypass this issue.
Program indicators of analytics type ‘Enrollment’ cannot be dispalyed using the Events Reports app. Why is that so?
If an event has three input fields and 4 other fileds that are assigned with calculations from the previous three fields, the program rules are not calculating in real time. This is because DHIS2 needs action in the event itself, like populating a value to trigger the calculations.
Tracker Sections and Section description cannot be translated through the user interface. Section description do not get translated even via json import
Are you planning on enabling tracker historical data import, preferably using a csv? In all projects that I have worked so far, there has been historical data for iimport. It would be really nice if csv data import (respecting the proper DHIS2 formatting of course) is available.
For indicators that are displayed on Tracker data entry form, it would be nice to be able to custom arrange them. Now tracker just displays them in a chaotic order. I don’t think it is even alphabetical.
Hello experts,
When Auto generating Unique ID’s, there is an example ######## that whatever you create cant work. Please advise what characters, integers etc to use.
Can you explain the idea behind the Analytics period boundaries for event and enrollment.
Lets say for instance I want to count the number of patients in a specific program and from the enrolled patients, I’d like to know how many have data in a specific stage of a program.
The other question I have is related to data desegregation. What if I want to do desegregation per age how would I perform?
Do you have any plans in the roadmap to be able to map Program Indicators to Data Elements with catcombos. The current catcombo UIDs are not really useful in that you cannot directly populate an aggregated data element with catcombos other than using some complex ETL process mapping.
Hi, can a data element or indicator from a previous period be used to calculate a current value. For example, numerator from 6 months ago and denominator for current or another period (September or October 2020).
Thank you
@moses_mwale are you generating a unique ID for a Tracked Entity Attribute or are you attempting to do that for another type of object? (I ask because I want to generate a unique ID without incorporating a TE Attribute into my program. I want to keep it as an Event Program.)
Hi, can we have the program indicators of new client and old clients for the tracker data? For new clients we count enrollment data but for old clients could you please specify the expressions?
I have following use case regarding program indicators.
Use case descriptions:
I am using tracker capture program to handle billing data.
For each billing items I have created one events. As a concrete example
lets assume I have two events,
E1–consultation fees —10----billing id: 1245
E2-ANC1 visit —0----billing id:1245
Is there any way to calculate my revenue from ANC visits using program indicator? Only two events are sharing common billing id. As ANC visit is part of part of billing 1245, we want to count consultation fees as a revenue for ANC visit.
I posted my question yesterday reposting here again. Looking forward to get your expert opinion on it.
I know I’ve posted this question or requirement many times, but because it’s so helpful feature.
Is it possible to make program indicator that are created on the event level to work with data elements in the reports like event report, for example certain data elements based on age group (which is program indicator).
For this case it might be good to use analytics period boundaries. You can have both event and enrollment period boundaries, which would capture “old client” enrollments from previous periods.
For example, this would include all events WITHIN this reporting period, for enrollments within this period AND 5 years before the start of the reporting period.
If looking on pivot table for Year 2020, events within 2020, and enrollments from 2015 through end 2020.
Actually “New Client” is the client who visits facility for the first time and “Old Client” is one who comes for follow up visit.
For eg: Client receives Injectable FP service for first time its new client and again comes back after 3 months for another service then the client is old client.
I hope I made you clear.
Hi @Oluwaseun,
If you are creating an indicator with numerator from 6 months ago and denominator from current period – and the numerator and denominator are enrollment counts from 6 months ago – this may be possible with offset periods analytic period boundaries.
However, I dont think this is possible within an enrollment, e.g. “the average difference between a child’s weight 6 months ago compared to the current month”.
I have another two questions about how to set up program indicators that make a calculation across multiple stages.
