Re: [Dhis2-users] Cumulative numbers in DHIS2

Hi Jim I will outline my approach here. Create some dummy data elements which will be used for the cumulative data. Data will be drawn from the "datavalue" table. There are two ways which we have used to aggregate the data 1) In Postgresql using a window-aggregate function 2) in R with the "cums

Re: [Dhis2-users] Cumulative numbers in DHIS2

Hi Jim, This is very similar to the data element that many countries use for family planning users at the end of the month and you are right it is a bit of a pain that DHIS-2 doesn’t support this sort of analysis right out of the box. We have health facilities report this cumulative indicator

Re: [Dhis2-users] Cumulative numbers in DHIS2

Hi Jason, Thanks, that sounds like the best option for us. I had almost gotten there myself. I've just been describing to our M&E folks the various suggestions I've received (thanks by the way Knut for the HTML report idea!) They are having a hard time understanding why something so easy in Exc

Re: [Dhis2-users] Cumulative numbers in DHIS2

Hi - I also want to run this kind of calculations - at the moment, for my demos, all I have is a SQL that updates/ insert values on DataElements that I've created just to contain this calculated values. I do this to move a stock closing balance as opening balance for the next month, calculate avera

[Dhis2-users] A chart saved as 'Public' doesn't get offered for inclusion into other users' dashboards

Am I doing something wrong or is this a bug? (2.11) This 45s video shows the problem A chart created by User A is available to a user B on the data visualizer as a favourite. It can be loaded, changed and saved. But then when user B tries to add it to

Re: [Dhis2-users] Cumulative numbers in DHIS2

Hi Jim, Personally, I think the easiest way would be an external script which would process the data and then inject it back into the aggregateddatavalue table. Some might call this a "hack", but we have used this approach for calculation of these types of cumulative numbers and it seems to work

Re: [Dhis2-users] Cumulative numbers in DHIS2

Not sure how helpful this is in your case, but I would think you could achieve this using the Web API in an HTML report, where you will be able to send in parameters. Knut On Thu, May 16, 2013 at 2:47 PM, Jim Grace wrote: > Hi Jason, > > Thanks. I agree it's best not to collect a cumulative am

Re: [Dhis2-users] Cumulative numbers in DHIS2

P.S. I was also hoping we could pull all our needed data into pivot tables. But it looks like these can't contain our "ever enrolled" number unless we collect it as a data element. On May 16, 2013, at 3:47 PM, Jim Grace wrote: > Hi Jason, > > Thanks. I agree it's best not to collect a cumulat

Re: [Dhis2-users] Cumulative numbers in DHIS2

Hi Jason, Thanks. I agree it's best not to collect a cumulative amount as a data element when it could be derived. You've given me some ideas how to pull it out -- for instance I see I can write a Jasper report based on a query. Although otherwise I was thinking we could pull all the data we ne

Re: [Dhis2-users] Cumulative numbers in DHIS2

Hi Jim, I have seen this exact same data element being collected USAID/PEPFAR supported organisations in Nigeria, Different organisations there, follow different approaches, either of collecting it in the way which you mention, or recording the cumulative figure each month. In the context of DHIS2,

[Dhis2-users] Cumulative numbers in DHIS2

Hi All, My PEPFAR partner organization FACES in Kenya is configuring our own DHIS2 instance to collect data among the clinics we support. One of the standard government variables we collect and report each month is "ever enrolled in [HIV/AIDS] care". This means the cumulative number enrolled si