Insight Connected Ticket Summary and Status

Questions & Answers
1

Hi There,

I’m building a report with Insight integration where I want to report the Insight Object records with specific attributes from the connected ticket (Summary and status).

Currently I have to use the “Jira Issue” dimension and have user defined measures to just gather the specific Jira Ticket Information and the “Issues Created” measure has be selected.

Example:

image
image1312×648 41.5 KB

Is there a more effective way to report this so that I can display the report without having to select the “Jira Issue” dimension as follows?

image

Regards,

Fabian

2

Hi Fabian,

Yes, it is possible to access the properties of the Jira issues with the custom measure. Note, however, that there might be several issues linked to this object, so the formula should consider that. I tried the following measure for showing the statuses of linked issues of objects:

Generate(
Filter(
  Descendants([Jira Issue].CurrentMember,[Jira Issue].[Issue]),
  [Measures].[Issues created]>0
),
[Jira Issue].CurrentMember.getstring("Status"),
","
)

image
image1882×656 61.5 KB

Kindly,
Janis, eazyBI support

3

Thanks Janis.

Exactly what I needed!