← Back to team overview

dhis2-devs team mailing list archive

Re: [Dhis2-users] Program data into dataset

 

Any help on this?

Regards
Pramil

On Sat, May 7, 2016 at 8:53 PM, Pramil Liyanage <pramilcl@xxxxxxxxx> wrote:

> Thanks Lars. Let me summarize my issue. We have been using aggregated
> reporting for TB for a few years and recently introduced individual records
> and aggregated using query builder to the same aggregated dataset. This was
> customized to the exact national paper report and report was generated from
> dataset report for printing.
>
> Now since agg. queries are not there we will not be able to get data from
> tracker into the same data element. If we shift to a new report using
> program indicators we will not be able to use the previous aggregate data
> in future analysis and comparison.
>
> To make the matter worse, there was a lot of disaggregation of data
> elements using categories, where we wrote queries for each one.
>
> We are stuck at a dead end at 2.22! Please suggest the best solution.
>
> Your suggestion to have program indicators in the custom dataset is a good
> idea for future. But my issue is get them into existing elements if I
> upgrade to 2.23, and not a few, about 700 in all reports.
>
> Regards
> Pramil
>
>
>
>
>
> On Fri, May 6, 2016 at 6:55 PM, Pamod Amarakoon <pamodm@xxxxxxxxx> wrote:
>
>> Dear Lars,
>>
>> Making aggregated event data available on the fly in data set report
>> would certainly be a useful tool especially when maintaining monitoring and
>> evaluation forms for tracker activities.
>>
>> Thank you
>>
>> On Fri, May 6, 2016 at 6:35 PM, Lars Helge Øverland <lars@xxxxxxxxx>
>> wrote:
>>
>>> Hi Pramil,
>>>
>>> you can retrieve aggregated event data from the analytics api.
>>>
>>> http://dhis2.github.io/dhis2-docs/master/en/developer/html/ch01s32.html
>>>
>>>
>>> Excerpt from the docs:
>>>
>>> To query for program data elements (of tracker domain type) you can get
>>> those by specifying the program for each data element using the
>>> <program-id>.<dataelement-id> syntax:
>>>
>>> /api/analytics.json?dimension=dx:eBAyeGv0exc.qrur9Dvnyt5;eBAyeGv0exc.GieVkTxp4HH
>>> &dimension=pe:LAST_12_MONTHS&filter=ou:ImspTQPwCqd
>>>
>>> One work-around could be to write a bit of Javascript and include that
>>> in the custom form to retrieve and display event based aggregated data
>>> inside the data entry form, if that is what you are looking to do.
>>>
>>>
>>> I have been pondering for a while on adding a feature where you could
>>> specify tracker-type data elements in custom data entry forms, and have the
>>> system automatically display aggregated event data, both in forms and in
>>> data set report. Let me know if that could work.
>>>
>>>
>>> regards,
>>>
>>> Lars
>>>
>>>
>>>
>>>
>>>
>>>
>>> On Thu, May 5, 2016 at 11:03 AM, Pramil Liyanage <pramilcl@xxxxxxxxx>
>>> wrote:
>>>
>>>> Hi everyone,
>>>>
>>>> Since the aggregation queries are not there anymore is it possible to
>>>> get program indicator value into an existing Aggregate Dataset through data
>>>> entry screen design?
>>>>
>>>> Or any other alternative workaround?
>>>>
>>>> Regards
>>>> Pramil
>>>>
>>>> _______________________________________________
>>>> Mailing list: https://launchpad.net/~dhis2-users
>>>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>> More help   : https://help.launchpad.net/ListHelp
>>>>
>>>>
>>>
>>>
>>> --
>>> Lars Helge Øverland
>>> Lead developer, DHIS 2
>>> University of Oslo
>>> Skype: larshelgeoverland
>>> lars@xxxxxxxxx
>>> http://www.dhis2.org <https://www.dhis2.org/>
>>>
>>>
>>> _______________________________________________
>>> Mailing list: https://launchpad.net/~dhis2-devs
>>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>>
>> --
>> Regards,
>> Pamod Amarakoon
>>
>> Confidentiality Notice: the information contained in this email and any
>> attachments may be legally privileged and confidential. If you are not an
>> intended recipient, you are hereby notified that any dissemination,
>> distribution, or copying of this e-mail is strictly prohibited. If you have
>> received this e-mail in error, please notify the sender and permanently
>> delete the e-mail and any attachments immediately. You should not retain,
>> copy or use this e-mail or any attachments for any purpose, nor disclose
>> all or any part of the contents to any other person.
>>
>>
>>
>>
>

Follow ups

References