Home » Developer & Programmer » Reports & Discoverer » Reports 12c Pie chart graph aggregate (Reports 12c)
Reports 12c Pie chart graph aggregate [message #689285] Wed, 08 November 2023 05:36 Go to next message
kuwait
Messages: 55
Registered: October 2007
Member
Hello,

I am using Oracle Reports 12c, and I have created a pie chart. I would like to know how to group or aggregate values that are less than 5% into a single slice, which I'd like to call "other." I've tried searching, and I've come across a property called "otherThreshold," but I cannot seem to locate it within the report wizard.

Thank you.
Re: Reports 12c Pie chart graph aggregate [message #689289 is a reply to message #689285] Wed, 08 November 2023 14:27 Go to previous messageGo to next message
Littlefoot
Messages: 21811
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I can't speak from Reports 12c perspective as I quit using Reports with its 10g version.

However: could you prepare data in a query (possibly create a view), and then let chart use such a prepared data, where all values less than 5% are already aggregated into "Other"?
icon14.gif  Re: Reports 12c Pie chart graph aggregate [message #689291 is a reply to message #689289] Wed, 08 November 2023 22:56 Go to previous messageGo to next message
kuwait
Messages: 55
Registered: October 2007
Member
Thank you Littlefoot,

I'll try your proposed solution.

Update:

I resolved the problem by writing an SQL query within the report's Data Model and linking it to this graph.

Thanks

[Updated on: Thu, 09 November 2023 04:11]

Report message to a moderator

Re: Reports 12c Pie chart graph aggregate [message #689292 is a reply to message #689291] Thu, 09 November 2023 05:28 Go to previous message
Littlefoot
Messages: 21811
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Great, I'm glad you made it work! Thank you for letting us know.
Previous Topic: shows record on matrix report
Next Topic: GOBAT60.EXE HAS STOP WORKING
Goto Forum:
  


Current Time: Sun Jun 16 03:11:57 CDT 2024