Is there a way set GroupBy in portal reports and pass Non groupby field as filters in QeryProcessAnalytics function?

Is there a way set GroupBy in portal reports and pass Non groupby field as filters in QeryProcessAnalytics function?

OriginalPostID-187220

  Discussion posts and replies are publicly visible

Parents
  • @sarvanana To the best of my knowledge it's not possible with the OOTB features because the data with which queryAnalytics interacts in the report is the grouped data. As we are going to set the grouping in the report, filters will be already set on the actual columns in the report and any filters which we sent from queryAnalytics act only on the grouped data. It could be possible by writing the expression rules but it make the use case highly complex and processing time would be high. Let's see if other practitioners could make valuable suggestions.
Reply
  • @sarvanana To the best of my knowledge it's not possible with the OOTB features because the data with which queryAnalytics interacts in the report is the grouped data. As we are going to set the grouping in the report, filters will be already set on the actual columns in the report and any filters which we sent from queryAnalytics act only on the grouped data. It could be possible by writing the expression rules but it make the use case highly complex and processing time would be high. Let's see if other practitioners could make valuable suggestions.
Children
No Data