Re: [Dhis2-users] Indicator: Numerator and Denominator objects not found.
Hi Lars, Agreed. I imported data elements metadata but yet still, some are not mapped in the indicators. I resorted to manually pointing the indicator related data elements to the correct source. This could be a very tedious process if I had so many indicators. I believe there could a better way of doing it. Thank you == Isaiah Nyabuto +254729572616 Bsc. Health Records Management and Informatics On Mar 16, 2018 18:27, "Lars Helge Øverland"wrote: Hi Isaiah, very likely you have exported and then imported indicators without including the data elements part of your indicator expressions. Currently we have a set of options under "metadata export with dependencies" (see Import-export app), but we don't support indicators with related metadata yet. It would be good to support that. I the mean time you need to import your data elements manually as well. regards, Lars On 16 March 2018 at 12:27, Isaiah Nyabuto wrote: > Hi David: > > Thank you. I can see that. Firstly I discovered that the numerators and > denominators data elements uids are not existing in my database. Is there a > way I can filter metadata by the date it was last updated? > > Thank you > > On Fri, Mar 16, 2018 at 12:23 PM, David Muturi wrote: > >> Hi Isaiah, >> The uid showing on the screen should be that of the data element (please >> check that it is correct). Also it should be enclosed in the chars as shown >> #{uid}. >> rgds >> David >> >> >> On Fri, 16 Mar 2018, 08:11 Isaiah Nyabuto, >> wrote: >> >>> Dear Dhis2 users, >>> >>> I recently imported a few indicators using an API. When I check the >>> indicator numerator from the maintenance, it shows the data element >>> description and ID but no valid object found. I suspect this could be a >>> problem with my metadata version. If so, how do I ensure I get the right >>> version of data elements metadata? >>> >>> Thank you. >>> >>> >>> == >>> Isaiah Nyabuto >>> +254729572616 <+254%20729%20572616> >>> Bsc. Health Records Management and Informatics >>> ___ >>> 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 >>> >> > > > -- > > > Isaiah Nyabuto > +254 729 572 616 > Bsc. Health Records Management & Informatics, JKUAT. > > ___ > 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 > > -- Lars Helge Øverland Technical lead, DHIS 2 University of Oslo l...@dhis2.org https://www.dhis2.org ___ 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
[Dhis2-users] Approval Status in Analytics
Hi All, Is there a way to check and display approval status in analytics(pivot tables, chats)?, I know there a manual way to check for approval by org units in Report app. My use case is to have an indicator or data element that will display and update the approval status when it's changed(Approved or Unapproved). Thanks, Bayoh. -- Ibrahim Bayoh ___ 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
Re: [Dhis2-users] Indicator: Numerator and Denominator objects not found.
Hi Isaiah, very likely you have exported and then imported indicators without including the data elements part of your indicator expressions. Currently we have a set of options under "metadata export with dependencies" (see Import-export app), but we don't support indicators with related metadata yet. It would be good to support that. I the mean time you need to import your data elements manually as well. regards, Lars On 16 March 2018 at 12:27, Isaiah Nyabutowrote: > Hi David: > > Thank you. I can see that. Firstly I discovered that the numerators and > denominators data elements uids are not existing in my database. Is there a > way I can filter metadata by the date it was last updated? > > Thank you > > On Fri, Mar 16, 2018 at 12:23 PM, David Muturi wrote: > >> Hi Isaiah, >> The uid showing on the screen should be that of the data element (please >> check that it is correct). Also it should be enclosed in the chars as shown >> #{uid}. >> rgds >> David >> >> >> On Fri, 16 Mar 2018, 08:11 Isaiah Nyabuto, >> wrote: >> >>> Dear Dhis2 users, >>> >>> I recently imported a few indicators using an API. When I check the >>> indicator numerator from the maintenance, it shows the data element >>> description and ID but no valid object found. I suspect this could be a >>> problem with my metadata version. If so, how do I ensure I get the right >>> version of data elements metadata? >>> >>> Thank you. >>> >>> >>> == >>> Isaiah Nyabuto >>> +254729572616 <+254%20729%20572616> >>> Bsc. Health Records Management and Informatics >>> ___ >>> 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 >>> >> > > > -- > > > Isaiah Nyabuto > +254 729 572 616 > Bsc. Health Records Management & Informatics, JKUAT. > > ___ > 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 > > -- Lars Helge Øverland Technical lead, DHIS 2 University of Oslo l...@dhis2.org https://www.dhis2.org ___ 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
Re: [Dhis2-users] Insight on program indicator and rule
Natalie, In addition to what Markus and Prosper have suggested, do you have access to the logs of your server? That can be a very useful source of information especially when trying to debug program indicators. I will usually set up a terminal tailing the log and then try to view my program indicator in one of the analytics apps. You'll see a lot of angry error messages if it isn't properly formulated and can give some better clues as to why. One time I had an expression that was considered valid by the edit screen but was failing when trying to view in analytics. Turned out it was because my spacing was off in between multiple d2:condition statements. The only way I figured it out was by watching the logs and saw a malformed sql query error. Good luck! Aaron -- Aaron C. White 919.522.5585 On Fri, Mar 16, 2018 at 7:39 AM, Prosper BTwrote: > Hi Natalie, > > In addition to Markus advice above, also check the you use of brackets, > they are not balanced > > (d2:daysBetween(A{Date of birth},V{enrollment_date}) / 365) in this > expression, you are dividing before executing and calcultating the entire > days between, should be > > (d2:daysBetween(A{Date of birth},V{enrollment_date})) / 365 > > But better to use years between as Markus advises > > Regards > > Prosper Behumbiize, MPH > DHIS2 Implementation Adviser| HISP Uganda > pros...@hispuganda.org | pros...@dhis2.org | Skype: > prospertb > > On Thu, Mar 15, 2018 at 9:19 PM, Markus Bekken wrote: > >> Hi there Natalie! >> Your program indicator looks all good. Can it be that the aggregation >> type is not "Count"? If your expression is a count, then the aggregation >> type needs to be "Count" or "Custom" for advanced cases. >> Tip: There is also a d2:yearsBetween function. >> >> For the program rule, I wonder if your A{Agree to be contacted} field >> might be of datatype "Yes/No"? If so, the correct syntax would be: >> A{Agree to be contacted} == false >> >> What version of DHIS2 are you on? >> >> Best regards, >> Markus >> >> 15. mar. 2018 kl. 18:33 skrev Natalie Tibbels : >> >> Hi all, >> Wondering if anyone could help with an indicator and a program rule. >> >> *What is wrong with this indicator (to calculate age from date of birth):* >> Want to count total enrollments where age is 35-39 >> >> Expression: >> V{enrollment_count} >> >> Filter: >> (d2:daysBetween(A{Date of birth},V{enrollment_date}) / 365) >= 35 and >> (d2:daysBetween(A{Date of birth},V{enrollment_date}) / 365) <= 39 >> >> [In the actual expression, the date of birth is the UID for date of birth] >> >> It’s producing no data but there should be some – think I’m making a >> simple mistake. >> >> >> *What is wrong with this program rule:* >> If the person says "no" for agreement to be contacted, hide the phone >> number field >> >> Name: Hide phone number field >> >> Expression: A{Agree to be contacted} == 'No' >> >> BUT, when I test it, if I click “Yes, agree to be contacted” the phone >> number disappears and if I click “No” the phone number remains. So the >> opposite of what I want…. >> >> Thanks for any suggestions! >> >> >> ___ >> 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 > > ___ 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
Re: [Dhis2-users] Insight on program indicator and rule
Hi Natalie, In addition to Markus advice above, also check the you use of brackets, they are not balanced (d2:daysBetween(A{Date of birth},V{enrollment_date}) / 365) in this expression, you are dividing before executing and calcultating the entire days between, should be (d2:daysBetween(A{Date of birth},V{enrollment_date})) / 365 But better to use years between as Markus advises Regards Prosper Behumbiize, MPH DHIS2 Implementation Adviser| HISP Uganda pros...@hispuganda.org| pros...@dhis2.org | Skype: prospertb On Thu, Mar 15, 2018 at 9:19 PM, Markus Bekken wrote: > Hi there Natalie! > Your program indicator looks all good. Can it be that the aggregation type > is not "Count"? If your expression is a count, then the aggregation type > needs to be "Count" or "Custom" for advanced cases. > Tip: There is also a d2:yearsBetween function. > > For the program rule, I wonder if your A{Agree to be contacted} field > might be of datatype "Yes/No"? If so, the correct syntax would be: > A{Agree to be contacted} == false > > What version of DHIS2 are you on? > > Best regards, > Markus > > 15. mar. 2018 kl. 18:33 skrev Natalie Tibbels : > > Hi all, > Wondering if anyone could help with an indicator and a program rule. > > *What is wrong with this indicator (to calculate age from date of birth):* > Want to count total enrollments where age is 35-39 > > Expression: > V{enrollment_count} > > Filter: > (d2:daysBetween(A{Date of birth},V{enrollment_date}) / 365) >= 35 and > (d2:daysBetween(A{Date of birth},V{enrollment_date}) / 365) <= 39 > > [In the actual expression, the date of birth is the UID for date of birth] > > It’s producing no data but there should be some – think I’m making a > simple mistake. > > > *What is wrong with this program rule:* > If the person says "no" for agreement to be contacted, hide the phone > number field > > Name: Hide phone number field > > Expression: A{Agree to be contacted} == 'No' > > BUT, when I test it, if I click “Yes, agree to be contacted” the phone > number disappears and if I click “No” the phone number remains. So the > opposite of what I want…. > > Thanks for any suggestions! > > > ___ > 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
Re: [Dhis2-users] Indicator: Numerator and Denominator objects not found.
Hi David: Thank you. I can see that. Firstly I discovered that the numerators and denominators data elements uids are not existing in my database. Is there a way I can filter metadata by the date it was last updated? Thank you On Fri, Mar 16, 2018 at 12:23 PM, David Muturiwrote: > Hi Isaiah, > The uid showing on the screen should be that of the data element (please > check that it is correct). Also it should be enclosed in the chars as shown > #{uid}. > rgds > David > > > On Fri, 16 Mar 2018, 08:11 Isaiah Nyabuto, > wrote: > >> Dear Dhis2 users, >> >> I recently imported a few indicators using an API. When I check the >> indicator numerator from the maintenance, it shows the data element >> description and ID but no valid object found. I suspect this could be a >> problem with my metadata version. If so, how do I ensure I get the right >> version of data elements metadata? >> >> Thank you. >> >> >> == >> Isaiah Nyabuto >> +254729572616 >> Bsc. Health Records Management and Informatics >> ___ >> 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 >> > -- Isaiah Nyabuto +254 729 572 616 Bsc. Health Records Management & Informatics, JKUAT. ___ 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
Re: [Dhis2-users] Indicator: Numerator and Denominator objects not found.
Hi Isaiah, The uid showing on the screen should be that of the data element (please check that it is correct). Also it should be enclosed in the chars as shown #{uid}. rgds David On Fri, 16 Mar 2018, 08:11 Isaiah Nyabuto,wrote: > Dear Dhis2 users, > > I recently imported a few indicators using an API. When I check the > indicator numerator from the maintenance, it shows the data element > description and ID but no valid object found. I suspect this could be a > problem with my metadata version. If so, how do I ensure I get the right > version of data elements metadata? > > Thank you. > > > == > Isaiah Nyabuto > +254729572616 > Bsc. Health Records Management and Informatics > ___ > 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