Create a chart with selected labels imported from JIRA

[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