Skip to Content
0

RE : How to Calculate Row and Coloumn Count from different blocks in webi

Jan 16, 2017 at 08:32 AM

42

avatar image
Former Member

Hi,

We have created a report in webi Rich client, As per requirement we have different unit of measures and created report with different blocks and applied conditional formatting with colors (R/G/Y) by applying Threshold values. Now the requirement is to Calculate Row and Column count and display them as Percentages how many Reds/ greens/Yellows in both Row and Column of the report. For example : Row Count it should count how many R/G/Y from different blocks( As we have different unit of measures and created report with different blocks) and display them as percentages. How to calculate the count of colors (R/G/Y) in different blocks and in a single table with all the blocks included in it? Please find the below sample screen shot.

vqqie.png (14.3 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Koen Hesters Jan 16, 2017 at 01:21 PM
0

Hi,

you will have to create variable measures who calcalute the R/G/Y values, something like...

count R = if sum((dimension) foreach(dimension))>= conditionvalue then 1 else 0

it will be not easy to create the measures, but it is in most cases possible.

Grtz

Koen

Share
10 |10000 characters needed characters left characters exceeded