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. ;|