Can I do filtering and aggregation in getportalreportdatasubset() ?

@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.

@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.