End to end mapping report based on custom field

Questions & Answers
,
1

image
image1007×163 4.02 KB

Hi I am try to create above report but I am having diffuclity , I tried all possible way based on my knowledge but its not working.

I have two Project GWOUR and ABC
in GWO UR project I have a stoty GWOUR-123 this has a custom field -Recommendation-ID[Multiple issue picker]this custom will hold multiple key of Recommendation issue type in same GWOUR project. In above example GWOUR-456 and GWOUR-457 list exist in this custom fied.
then these individual recommendations also have a Custom field “GWO test ID” [Multiple issue picker].

So in this GWO test ID will hold key values from ABC project, in above example GWOUR-456 having ABC-1 and GWOUR-457 is having ABC-2 in this field.

Could you please suggest how can I create this End to end mapping report in EazyBI, I have imported both project data into one queue.
@zane.baranovska @roberts.cacus @gerda.grantina

1 Like
2

Hi,

The solution will be possible if you use specific advanced settings for the issue picker custom fields:

# some multiple issue picker
[jira.customfield_17500]
data_type="string"
multiple_values=true
dimension=true
properties_from_dimension="Issue"

With such options, the dimension will show the issue key and summary and you can create two first columns of the report:

image
image2208×1030 329 KB

Adding next level is more tricky, but still possible. I added to the report rows the dimension for the third level issue link, and created a measure for filtering:

DefaultContext((
  [Measures].[Issues created],
  [Issue].[Issue].GetMemberByKey(
    [Some multiple Issue picker].CurrentMember.KEY
  ),
  [Some issue picker].CurrentMember
))

I added the row filter on this measure and now I can see all three levels of links:

image
image2688×942 254 KB

Kindly,
Janis, eazyBI support

3

@janis.plume
Thank you for you response and time, I have changes a approach, instead of custom field issue picker, i am now using issue link field. (Inward, outward link)
I have also added advance setting for importing this as customfield.
when I execute your solution, i can see eveything seems repeating on level 2 hence . on third level all seems repeating.
please find below image for all the information i have. I will really apperciate if you can help here

image
image1651×814 82.8 KB

4

@janis.plume any update on this please?

5

Hi,

The issue link dimensions seems to work differently.
I checked that in the case of the links you need to use two conditions. You should keep the filer you have now, but you should add another:

([Measures].[Issues created],
 [GWO Linked to Rec].CurrentHierarchy.DefaultMember)

So, if you put condition on both those measures, no duplicates should appear. Note, however, the link dimensions does not have the (none) member which is why you might not see a full picture in the report.

Kindly,
Janis, eazyBI support