OraFAQ Forum: Reports & Discoverer » Reports 12c Pie chart graph aggregate

Home » Developer & Programmer » Reports & Discoverer » Reports 12c Pie chart graph aggregate (Reports 12c)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Reports 12c Pie chart graph aggregate [message #689285]

Wed, 08 November 2023 05:36

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.

Report message to a moderator

Re: Reports 12c Pie chart graph aggregate [message #689289 is a reply to message #689285]

Wed, 08 November 2023 14:27

Littlefoot
Messages: 21808
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"?

Report message to a moderator

Re: Reports 12c Pie chart graph aggregate [message #689291 is a reply to message #689289]

Wed, 08 November 2023 22:56

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

Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Great, I'm glad you made it work! Thank you for letting us know.

Report message to a moderator

Previous Topic:	shows record on matrix report
Next Topic:	GOBAT60.EXE HAS STOP WORKING

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 27 17:45:32 CDT 2024