Skip to main content

Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » Calculating percentage in data cube
Calculating percentage in data cube [message #1834379] Mon, 09 November 2020 11:53 Go to next message
doaa farouk is currently offline doaa faroukFriend
Messages: 1
Registered: November 2020
Junior Member

We'd like to display a chart of the percentage of complaints grouped by status, but the percentage built-in function does not exist in a data cube measure.

So, we created a computed column for the count, and another computed column for percentsum, which calculates the sum of count.

Now, we're not able to use this method, as the percentsum expression does not accept another aggregate column.

Any clue, how to implement this.

Re: Calculating percentage in data cube [message #1834465 is a reply to message #1834379] Tue, 10 November 2020 18:17 Go to previous message
rbaak Mising name is currently offline rbaak Mising nameFriend
Messages: 31
Registered: July 2009
You might need to calculate those percentages in SQL(if you are using a database) then bring them into the report.

Previous Topic:Birt - Insert Dynamic text box with script
Next Topic:Export rptdocument as JSON
Goto Forum:

Current Time: Sat Jun 10 05:27:19 GMT 2023

Powered by FUDForum. Page generated in 0.02279 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top