Create a chart with selected labels imported from JIRA

[prai]

Hi ,

I need to create a chart which would display issues labelled in JIRA as as New, Maintenance, Innovation etc. and if possible to have it filtered by having last 5 Sprints closed. As I am new to EazyBI, I am not sure the fields that need to be selected and if I need to create any measure as many issues also contain multiple other JIRA labels associated with them. If anyone can help me in finding the right steps, it would be very helpful. Thanks.

Regards

[gerda.grantina]

Hi @prai,
you can add Label dimension in Pages and use that for filtering your report.

For filtering report for last 5 closed sprints you can use my colleagues trick & trip:

Filter your eazyBI for last 5 closed sprints

Hi This is an approach on how to filter the report for the last 5 closed sprints if you have other dimensions in pages which makes the report context. You could adjust the code to show more/less than 5 and also switch to show first sprints by changing the ordering conditions. First, you could create a new calculated measure (only to filter last 5 closed sprints sorted by sprint start dates) in your report using this code: Case when [Sprint].Currentmember.Level.Name = 'Sprint' Then Case whe…

Or create an aggregate member in your Sprint dimension that will show you last 5 closed sprints:

Aggregate({
Tail(
  Order(
    Filter([Sprint].[Sprint].Members,
    [Sprint].CurrentMember.getBoolean("Closed") 
    AND
    NOT IsEmpty([Sprint].CurrentMember.get("Complete date"))
    ),
    [Sprint].CurrentMember.get("Start date"),
    BASC
    ),5
  )
})

best,
Gerda // support@eazyBI.com