Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Jiju Rajan (JijRaj)
Commonwealth Bank of Australia

Commonwealth Bank of Australia
AU
JijRaj Member since 2015 3 posts
Commonwealth Bank of Australia
Posted: Apr 20, 2018
Last activity: Apr 26, 2018
Posted: 20 Apr 2018 8:21 EDT
Last activity: 26 Apr 2018 2:33 EDT
Closed
Solved

Not able to add intervals in axis for chart report definition

I need to group some values based on intervals in chart axis(i.e 0-5,5-10,10-15 etc) and group all the results between these interval.

Added the attachment and in x-axis i am having unique values bar graph depending on entries

Please let me know how to achieve in charts/report definition.

To see attachments, please log in.
Reporting

Accepted Solution

Posted: 6 years ago
Posted: 25 Apr 2018 4:56 EDT
Vineetha Kagitha (kagiv)
PEGA
Associate Technical Solutions Engineer
Pegasystems Inc.
IN

Hi,

You might not have the option to group values(like as you said) directly from charts, you must be creating a custom sql function to group the data according to your use case.

Please refer to this post https://docs-previous.pega.com/how-create-custom-sql-functions-reporting having similar requirement

 

Regards,

Vineetha

To see attachments, please log in.
Posted: 6 years ago
Posted: 26 Apr 2018 0:37 EDT
Jiju Rajan (JijRaj)
Commonwealth Bank of Australia

Commonwealth Bank of Australia
AU

Thanks Vineetha....created the Function Alias(Custom SQL) to achieve this and its working fine.

Attached the result

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice