Dear community,
I would like to output data in a tabular format (data elements in columns, orgUnits and periods per row) at the lowest level of orgUnits. In which way should I do that as data in text format could not be displayed through pivot table?
Thank you for your support!
Regards.
Tantely.
This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.
Hi Tantely,
we introduced a new analytics web API resource in 2.26 for “raw” data which you might find interesting. Docs:
https://docs.dhis2.org/master/en/developer/html/webapi_analytics.html#webapi_analytics_raw_data
It follows the same syntax as the regular analytics resource (at /api/analytics) but it does not perform any aggregation (e.g. in the org unit hierarchy dimension), and instead gives you the raw data in a tabular/grid format.
You can use the pivot table > download to browse your metadata, and then use the /api/analytics/rawData as base URL instead. Note that this might return a ton of data so you might want to split up into multiple requests.
Example:
You can use the outputIdScheme param to give you names instead of IDs:
You can also use the startDate and endDate params for more flexibility.
regards,
Lars
On Tue, Feb 7, 2017 at 6:41 PM, Raminosoa Rabemanantsoa, Tantely traminosoa@mikolo.org wrote:
Dear community,
I would like to output data in a tabular format (data elements in columns, orgUnits and periods per row) at the lowest level of orgUnits. In which way should I do that as data in text format could not be displayed through pivot table?
Thank you for your support!
Regards.
Tantely.
This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.
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
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
Dear Lars,
Thank you for those new development that have been newly introduced which are interesting. So for version 2.24, if we output raw data through SQL View, is it possible to integrate the results into dashboards?
Regards,
Tantely
This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.
On Tue, Feb 7, 2017 at 9:10 PM, Lars Helge Øverland lars@dhis2.org wrote:
Hi Tantely,
we introduced a new analytics web API resource in 2.26 for “raw” data which you might find interesting. Docs:
https://docs.dhis2.org/master/en/developer/html/webapi_analytics.html#webapi_analytics_raw_data
It follows the same syntax as the regular analytics resource (at /api/analytics) but it does not perform any aggregation (e.g. in the org unit hierarchy dimension), and instead gives you the raw data in a tabular/grid format.
You can use the pivot table > download to browse your metadata, and then use the /api/analytics/rawData as base URL instead. Note that this might return a ton of data so you might want to split up into multiple requests.
Example:
You can use the outputIdScheme param to give you names instead of IDs:
You can also use the startDate and endDate params for more flexibility.
regards,
Lars
On Tue, Feb 7, 2017 at 6:41 PM, Raminosoa Rabemanantsoa, Tantely traminosoa@mikolo.org wrote:
Dear community,
I would like to output data in a tabular format (data elements in columns, orgUnits and periods per row) at the lowest level of orgUnits. In which way should I do that as data in text format could not be displayed through pivot table?
Thank you for your support!
Regards.
Tantely.
This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.
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
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
–