Question

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

Comments

Keep up to date on this post and subscribe to comments

December 11, 2019 - 9:48am

Ideally, if we could divide the sum of column A by column B, Column C would be the result and would be usable for chart purposes. 

Pega
December 11, 2019 - 10:47am

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.

December 11, 2019 - 11:06am
Response to GeedA

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.  

Pega
December 11, 2019 - 10:49am

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