Reporting on issues that were created or modified after a specific date

Questions & Answers
1

Is there a way of reporting issues that were either created or modified after April 1, 2024?

2

Hi, @PRL

Welcom to the eazyBI community.

Please consider using measures: Issues created and Issues last updated. Read more about the measures here: Jira Core measures and dimensions

Measure “Issues last updated” when used with the Time dimension, the last update date shows the total count in the corresponding period. Use Page Filter to filter out the relevant Time period.

Kindly,
Ilze

3

I have 58 issues that were created on or after April 1st 2024.
I have 210 issues that were modified on or after April 1st 2024.
I need to see over all 268 issues.

Your recommendation only gives me issues that were modified on or after April 1st 2024 from the 58 that were created on or after April 1st 2024.

4

I put the Issues Created and the Issues Last Updated side by side for testing purposed. I did this by using the Issues Created and Issues last Updated measures and a user define Time measure like so
Aggregate([Time].[Day].DateMembersBetween(‘Apr 1 2024’,‘today’))

And I get the following…which gets me part of the way:

Delivery Category Issues Issues
last created
updated
XXX 635 4
XXXX 1
XXXXX 6 6
XXXXX 6 4
XX 110 102
XXXXXXX 2 1
X 410 254
Total 1,170 371

I would like there to be no double counting between the Issues Created and the Issues Last Updated rows. So for e.g. the 6 Issues Created in row 3 are the same 6 that were updated since Apr 1st 2024. I want to see just 6 not 12.

So I need a measure that looks at both Issue Created Date and Issue Last Updated Date and only returns issues that where either of these measures is > Apr 1st, 2024.

Here is the JQL I use for it:
project in (List of proejcts) AND issuetype in (Task, Defect, Story) AND (updatedDate >= 2024-04-01 OR createdDate >= 2024-04-01)

Thanks