Displaying an accurate percentage in a chart
I am currently attempting to display a % in a chart on a users dashboard. I need to take the sum of one column and divide it by the sum of another column. I have created a sub-report to give column a and b a Sum summarize selection. When dividing the sub reports 2 columns on the main report, there is no summarize option that yields correct data. Is there a way to display a chart without having to select one of the generic summarize selections?
Is this just not possible in Pega? This is a simple task in Excel but I cannot see a way to do this in Pega.
7.3.1
Pegasystems Inc.
IN
Hi,
In Pega, whenever you want to add a chart to a report definition at least one of the column should contain any of the "Summarize" option available by OOTB. Even though the sub report has the summarized column values the main report should contain atleast one aggregate column for enabling chart feature.
"You must save this report with at least one aggregated numeric column before defining a chart"
Hope this helps!
Thanks,
Geeda.
Centene Corporation
US
I have a chart, that is not problem. The problem is that all of the existing options for summarizing make the chart inaccurate. There is no option for = on a column that is a formula.
Pegasystems Inc.
IN
In an extension to the above comment, you can refer the below link for additional informatione realated to charts,
https://community.pega.com/knowledgebase/articles/reporting/working-charts-reports-pega-7