Eclipse Community Forums: BIRT » Calculating percentage in data cube

Home » Archived » BIRT » Calculating percentage in data cube

Calculating percentage in data cube [message #1834379]

Mon, 09 November 2020 06:53

Eclipse User

Hello,

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.

Thanks,

Re: Calculating percentage in data cube [message #1834465 is a reply to message #1834379]

Tue, 10 November 2020 13:17

Eclipse User

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:

-=] Back to Top [=-

Current Time: Tue Jun 17 17:20:18 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter