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.
Accepted Solution
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.pega.com/how-create-custom-sql-functions-reporting having similar requirement
Regards,
Vineetha
Coforge Technologies
AU
Thanks Vineetha....created the Function Alias(Custom SQL) to achieve this and its working fine.
Attached the result