EazyBI jql query

Questions & Answers
1

Hi,

I want help with how to create a dimension based on the below jql query. Hope you can help, thanks.

Status changed to Closed after startofweek(-2d) before endofweek(-2d)

2

@Rkakani

Welcome to eazyBI community.
I believe you don’t need new dimensions for your report
You can create a calculated measure that counts issues where status changed to Closed in 2 weeks ago period.

Sum(
{
[Time].[Day].DateMember([Time.weekly].[Week].CurrentDateMember.startdate).Lag(2):
[Time].[Day].DateMember([Time.weekly].[Week].CurrentDateMember.NextMember.startdate).Lag(2)
},
(
[Measures].[Transitions to status issues count],
[Transition Status].[Closed]
)
)

The first set would return the time period before last week’s 5day till this week’s 5day

Then you can filter the report by new measure (New measure > 0)

Martins / eazyBI support