Create a page filter to filter out issue for last week, this week and next week compare with issue start date

Questions & Answers
1

I would like to create a Page filter to let user select 1 of the 3 options

“last week issue” with To Do status
“This week days issue” with To Do status
“Next week issue” with To Do status

Compare with issue Start date in Jira
But it dont work as expected.

Thanks

Aggregate(

CASE WHEN

DateBetween([Time].CurrentHierarchyMember.StartDate,

[Measures].[Issue Start date],

[Measures].[Issue due date]

)

THEN 1

END
)

2

Hi, @wing
​
​Welcome to the eazyBI community.
​
To filter issues using the custom date field (in your case, “Start Date”):
​

  1. Import your custom date field as a measure. This will create measure “Issues with Start Date” . Read more here: Jira custom fields

  2. Define new calculated members in the Time dimension: For example - Next week:

    next week
    next week1304×436 24.4 KB

    The Current week, Previous week should be there already.

  3. Add future dates to the Time dimension to import options, if needed.

    Future dates
    Future dates1458×1290 96 KB

Read more here: Data from Jira

  1. Use the measure “Issues with Start date” with the Time dimension in the report :slight_smile:

Kind regards,
Ilze eazybi@support.com