Percentages (Rows & Columns)

Questions & Answers
1

Hello All,

I am fairly new to EazyBI and I would like to ask how to calculate percentage of total rows and columns in a table. The default % calculation feature returns the % of the row as opposed to the total. Any guidance is appreciated.

Thanks

2

Hi Sam,

The default calculation applied for the report columns (and shows up in the rows) takes the ratio of the value to all the visible rows:

image
image798×334 20.2 KB

A similar calculation can be implemented with a custom formula, with more flexibility, but that depends on the outlook of the report. For instance, if I have the following report and wish to see the percentages by priorities, the following formula would do that:

[Measures].[Issues created]/
([Measures].[Issues created],
[Priority].DefaultMember)

image
image1908×386 46.6 KB

Similarly, we can have the 100% at the total of rows with alternative formula:

[Measures].[Issues created]/
([Measures].[Issues created],
[Project].DefaultMember)

image
image1882×386 48.8 KB

Kindly,
Janis, eazyBI support

3

Thanks Janis! This has been really helpful!