EazyBI jql query


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)


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.

[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