Is there any way to make reports based on updated field instead of created when adding series?

Question

Good morning,

Is there any way to make reports based on updated field instead of created? Why updated field is not shown in predefined series?

When I want to make a graphic to show the tickets with updated date, which is something very important I think..., the report's system don't let you do just that.

Thanks in advance.

Ligia Merciu · Answer

Hi,

I really believe that all updates were done before "now()", so it's absolutely normal to have no filtering for this.

For statuses updates, use that

... status changed AFTER...
... status changed BEFORE...

with either a fix date or a negativ interval or one of startOf ...(), endOf...() functions

Internal Support_wq2xf7 · Answer

Hi,

I have already tried to use the "updated <= now()" in my jql sentences to cover my needs but it does not work... it does not shown the tickets that have statuses updated.

This is my jql sentence that I labeled as Tickets IN PROGRESS:

issuetype in (Bug, Incident, Support) AND status in ("Work in progress", "In Progress", Pending, "Waiting for customer", "Waiting for support") AND updated <= now()

But it still only shows me the tickets based on created field and not the updated field...

Thanks.

Ligia Merciu · Answer

Hi,

If you have defined your statuses as belonging to status categories, probably, you'd better use something like - this displays the issues that have changed statuses in the last day:

IN PROGRESS:

statusCategory = "In Progress" AND status changed AFTER -1d

or, more generally, for whatever changes have been made:

statusCategory = "In Progress" AND updated >= -1d

Obviously, you can use

statusCategory = Done

as well, for your purpose.

Be aware that update date is a date time field, not a date field and this might complicate the things a little bit, if you want a more refined representation.