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
Posted: 2 years ago
Posted: 2 years ago
Thanks Vineetha....created the Function Alias(Custom SQL) to achieve this and its working fine.
Attached the result
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://pdn.pega.com/how-create-custom-sql-functions-reporting having similar requirement
Regards,
Vineetha