Hello all
I am trying to create a filter that shows created within a particular month but also resolved within that same month regardless of created date. Meaning unlike widget which shows only issues created and resolved within same month, I am trying to filter on created (for example) this month and resolved this month regardless of when created. And trying to calculate these two sets of numbers going back 3 months.
Is this possible?
I kind of have this working for one month but only for resolved count, but I'm trying to pull counts going back to 10/1/21 that i can graph by month, for both created and resolved.
Here's what I use for one month:
project = ACME AND resolutiondate >= 2022-01-01 AND resolutiondate <= 2022-01-31 AND NOT resolution in (Unresolved) ORDER BY created DESC
Thanks so very kindly for any suggestions.