Tickets Closed from last sunday

I’m looking to find issues that are closed since latest “Sunday”. For example. if we’re looking at the report on Wednesday, then it should reflect tickets closed since last Sunday till now.

Any help is appreciated.

Hi @Sarath,

For relative date periods, like the current month, previous week, from last Sunday till today, etc., you might want to define a new calculated member in the Time dimension that would group days matching those criteria.

In your case, to get days from last Sunday till today, the formula for the calculated member is this:

Aggregate(
  [Time].[Day].DateMembersBetween('last sunday', 'today')
)

More details on relative periods and how to address them are here: Date filters - eazyBI for Jira.

In the report, set the Time dimension on rows and measure “Issues closed” on columns to see how many issues are closed since last Sunday.

Best,
Zane / support@eazyBI.com