Question

6
Replies
86
Views
AdamS229 Member since 2019 3 posts
TalkTalk
Posted: March 13, 2020
Last activity: August 31, 2020

Is there a Pega version of the RANK () OVER (PARTITION BY) function for a Report Definition?

Does Pega have its own version of this function?

For example as SQL it would be:

select

employee_name,

salary,

RANK() OVER (PARTITION BY department ORDER BY salary)

from employees

 

Is there anyway to replicate this in a Report Definition?

 

***Edited by Moderator Marissa to update General to Product; update Product details***  

Pega Platform Reporting Decisioning Consultant
Share this page LinkedIn