on 01-16-2017 8:32 AM - last edited on 02-03-2024 7:01 PM by postmig_api_4
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.