Counting dimensions which has non zero issue

yuhoon ki July 15, 2018

I have difficulites with counting categories which has issues. (none zero)

 

let's say there are 2 customfields such as team and module.

(I already imported customfileds as a dimension)

Team_customfiled contains a team name that the issues belong to.

Module_customfile contains a module name that issues belong to.

 

First, I tried to check how many issues are for each categories like below.

 

                Module A  | Module B |  Module C

Team  A      10           |    1           |        0

Team B      1              |     25        |     100

Team C      0             |       0         |      10

 

Then, I came to know about how many modules are involed in each team.

That is, I wanted to count modules that created issues are more than 1.

If I made a caculated member on measure or Module dimension with the name of 'InvovledModule#',

it's supposed to

                     InvolvedModule#

Team A                    2 (b/c module C has zero issue, only rest of 2 modules can be counted)

Team B                   3

Team C                  1 (only module C has more than 1 issue, it can be counted)

 

Please help this problem solved. ;|

 

 

0 answers

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events