Can I do filtering and aggregation in getportalreportdatasubset() ?

Try using a!queryProcessAnalytics() function
forum.appian.com/.../System_Functions.html

hi janakik, I tried this function but got an error: errorMessage=Grouping and aggregation are not supported. (APNX-1-4203-027)]

any idea?

@shaoyongw A very specific answer to your question is, you can't do aggregation operations with getportalreportdatasubset() or a!queryProcessAnalytics(). Documentation at https://forum.appian.com/suite/help/7.10/System_Functions.html#a!queryProcessAnalytics.28.29 says 'Columns cannot be selected or aggregated via the query parameter but can be configured in the portal report.' But still you can go ahead with applying filters using PortalreportFilter object in getportalreportdatasubset() or a!queryFilter in a!queryProcessAnalytics().

Please do let us know if you have any follow up questions.

This might be helpful.
forum.appian.com/.../

We are using Portal Reports to pull information on tasks (Owner,Region etc) using a!queryProcessAnalytics().I need to build the summary view for this Report that should representation the count of Tasks of Each Assignee of each region and the a!queryProcessAnalytics() doesn't support Aggregation . Is there any other alternative way to achieve this column aggregation so that I can list all the count of tasks for the Owner for the region?

@prajwalb There could be only two ways of doing this afaik:
1. Peforming the desired aggregation in the portal report itself
2. If you aren't able to do as mentioned above, then you would need to pull the data by using queryProcessAnalytics and then apply the grouping on the resultant dataset which needs customised rules to be built.