Thanx Knut. Will write a blueprint 
···
On Sat, Jan 23, 2016 at 3:30 AM, Knut Staring knutst@gmail.com wrote:
Knut
Unfortunately, I think filtering through measureCriteria is currently not supported by the Pivot Tables. Sounds like a feature that should be added (both in the GUI and in the model). Maybe you could write a Blueprint?
–
On Fri, Jan 22, 2016 at 12:02 PM, Pamod Amarakoon pamodm@gmail.com wrote:
Hi,
this is the json of analytic table I want to filter data of…
{
“lastUpdated”: “2016-01-22T08:20:21.575+0000”,
“href”: “http://xxx.xxx.224.242:3080/ncd/api/reportTables/Fmlq1WIqgeU”,
“id”: “Fmlq1WIqgeU”,
“created”: “2016-01-22T08:20:21.574+0000”,
“name”: “hlc-bmi_normal_female”,
“publicAccess”: “rw------”,
“userOrganisationUnitChildren”: false,
“hideEmptyRows”: false,
“parentGraphMap”: {
“GYBZ1og9bk7”: “”
},
“userOrganisationUnit”: false,
“rowSubTotals”: true,
“displayDensity”: “NORMAL”,
“completedOnly”: false,
“colTotals”: true,
“showDimensionLabels”: true,
“sortOrder”: 0,
“fontSize”: “NORMAL”,
“topLimit”: 0,
“aggregationType”: “DEFAULT”,
“userOrganisationUnitGrandChildren”: false,
“displayName”: “hlc-bmi_normal_female”,
“externalAccess”: false,
“colSubTotals”: true,
“showHierarchy”: false,
“rowTotals”: true,
“cumulative”: false,
“digitGroupSeparator”: “SPACE”,
“regression”: false,
“skipRounding”: false,
“reportParams”: {
“paramGrandParentOrganisationUnit”: false,
“paramReportingPeriod”: false,
“paramParentOrganisationUnit”: true,
“paramOrganisationUnit”: false
},
“access”: {
“read”: true,
“update”: true,
“externalize”: true,
“delete”: true,
“write”: true,
“manage”: true
},
“relativePeriods”: {
“thisYear”: false,
“quartersLastYear”: false,
“last52Weeks”: false,
“thisWeek”: false,
“lastMonth”: false,
“last2SixMonths”: false,
“monthsThisYear”: false,
“thisQuarter”: false,
“last12Months”: true,
“last5FinancialYears”: false,
“lastQuarter”: false,
“thisSixMonth”: false,
“thisFinancialYear”: false,
“last4Weeks”: false,
“last3Months”: false,
“thisMonth”: false,
“last5Years”: false,
“last6BiMonths”: false,
“lastFinancialYear”: false,
“last6Months”: false,
“quartersThisYear”: false,
“monthsLastYear”: false,
“lastWeek”: false,
“thisBimonth”: false,
“lastBimonth”: false,
“lastSixMonth”: false,
“lastYear”: false,
“last12Weeks”: false,
“last4Quarters”: false
},
“user”: {
“id”: “n6OIhU7cvg4”,
“name”: “Pamod Amarakoon”,
“created”: “2016-01-04T06:10:34.185+0000”,
“lastUpdated”: “2016-01-04T06:10:34.185+0000”,
“href”: “http://xxx.xxx.224.242:3080/ncd/api/users/n6OIhU7cvg4”
},
“attributeDimensions”: ,
“filterDimensions”: ,
“organisationUnitGroups”: ,
“itemOrganisationUnitGroups”: ,
“userGroupAccesses”: ,
“programIndicatorDimensions”: ,
“columnDimensions”: [“dx”],
“dataDimensionItems”: [{
“dataDimensionItemType”: “DATA_ELEMENT_OPERAND”,
“dataElementOperand”: {
“id”: “dHqbtLysQz0.fHcQdNbIBwQ”,
“name”: “HLC-BMI (BMI 18.5-24.9, Female)”
}
}],
“columns”: [{
“id”: “dx”
}],
“organisationUnitLevels”: ,
“dataElementDimensions”: ,
“periods”: ,
“organisationUnits”: [{
“id”: “GYBZ1og9bk7”,
“name”: “Sri Lanka”,
“code”: “Sri Lanka”,
“created”: “2015-04-02T01:20:14.000+0000”,
“lastUpdated”: “2016-01-04T05:41:00.657+0000”,
“href”: “http://xxx.xxx.224.242:3080/ncd/api/organisationUnits/GYBZ1og9bk7”
}],
“categoryDimensions”: ,
“dataElementGroups”: ,
“filters”: ,
“rows”: [{
“id”: “pe”
},
{
“id”: “ou”
}],
“categoryOptionGroups”: ,
“rowDimensions”: [“pe”,
“ou”]
}
–
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar
http://dhis2.org
On Fri, Jan 22, 2016 at 4:19 PM, Knut Staring knutst@gmail.com wrote:
Which is why I thought it might be useful to look at the format for favorites, like the one I sent you.
–
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.
On Fri, Jan 22, 2016 at 11:46 AM, Pamod Amarakoon pamodm@gmail.com wrote:
Formulating this was possible using something like,
http://xxx.xx.xx.xx:xxx/x/api/analytics.json?dimension=dx:dHqbtLysQz0.fHcQdNbIBwQ:eq:0&dimension=ou:GYBZ1og9bk7&dimension=pe:LAST_12_MONTHS&displayProperty=NAME&skipMeta=true&measureCriteria=GT:500;LT:1000
but just wanted to create a favorite item so it can be shared among user roles, where i ran in to problems.
–
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar
http://dhis2.org
On Fri, Jan 22, 2016 at 4:13 PM, Knut Staring knutst@gmail.com wrote:
Right - but was your problem how to formulate these, or how to post new favorites into DHIS2?
–
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.
On Fri, Jan 22, 2016 at 11:41 AM, Pamod Amarakoon pamodm@gmail.com wrote:
Thanx. There were in fact 2 scenarios. one example was to identify org units reporting zero values on a particular data element. The other was regarding resource allocation where they want to see facilities reporting values below a certain limit to decide on cutting down resources for coming years
–
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar
http://dhis2.org
On Fri, Jan 22, 2016 at 4:07 PM, Knut Staring knutst@gmail.com wrote:
Right, I was just commenting on the format, yours seemed very different (how did you come up with it?).
Probably best to wait for Morten to explain.
–
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.
On Fri, Jan 22, 2016 at 11:32 AM, Pamod Amarakoon pamodm@gmail.com wrote:
Hi Knut,
Thanx a lot. but in the above example is it possible to filter out range of data values. For example,
In my initial query it would show number of people who have BMI of 18-25 by org unit.
What if I want to filter out the list by org units which report values over 500.
–
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar
http://dhis2.org
On Fri, Jan 22, 2016 at 3:40 PM, Knut Staring knutst@gmail.com wrote:
Something like this maybe?
https://play.dhis2.org/demo/api/reportTables/tWg9OiyV7mu.json
–
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.
On Fri, Jan 22, 2016 at 11:00 AM, Pamod Amarakoon pamodm@gmail.com wrote:
Hi,
I wanted to create a new favorite at pivot table that filters the date values between a range of 500 to 1000.
I could get the output i needed using
http://xxx.xx.xx.xx:xxx/x/api/analytics.json?dimension=dx:dHqbtLysQz0.fHcQdNbIBwQ:eq:0&dimension=ou:GYBZ1og9bk7&dimension=pe:LAST_12_MONTHS&displayProperty=NAME&skipMeta=true&measureCriteria=GT:500;LT:1000
I wanted to create a favourite for the same. I posted following json to
/api/reportTables/
{
“columns”: [{
“dimension”: “dx”,
“items”: [{
“id”: “dHqbtLysQz0.fHcQdNbIBwQ”,
“name”: “BMI (BMI 18.5-24.9, Female)”
}]
}],
“rows”: [{
“dimension”: “pe”,
“items”: [{
“id”: “LAST_12_MONTHS”,
“name”: “”
}]
},
{
“dimension”: “ou”,
“items”: [{
“id”: “GYBZ1og9bk7”
}]
}],
“filters”: ,
“showDimensionLabels”: true,
“hideEmptyRows”: false,
“skipRounding”: false,
“aggregationType”: “DEFAULT”,
“dataApprovalLevel”: {
“id”: “DEFAULT”
},
“showHierarchy”: false,
“completedOnly”: false,
“displayDensity”: “NORMAL”,
“fontSize”: “NORMAL”,
“digitGroupSeparator”: “SPACE”,
“legendSet”: null,
“sorting”: null,
“regression”: false,
“measureCriteria”: “GT:500;LT:1000”,
“cumulative”: false,
“sortOrder”: 0,
“topLimit”: 0,
“rowTotals”: true,
“colTotals”: true,
“rowSubTotals”: true,
“colSubTotals”: true,
“reportParams”: {
“paramReportingPeriod”: false,
“paramOrganisationUnit”: false,
“paramParentOrganisationUnit”: true
},
“name”: “bmi_normal_female_w_LTGT”
}
But this doesn’t seem to work. what’s the dimension/criteria I should use to get this done.
–
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.
Thank you
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar
http://dhis2.org
–
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.