How can I track total tickets ever in "under review" status by user?

[Chegg Coop]

Is there an easy way to set up a filter or two dimensional filter statistics table on the dashboard that helps track the total number of tickets ever in "under review" status by user? Ideally this data would show username, total lifetime unique tickets ever "under review", and total lifetime unique tickets ever "rejected" and "cancelled."

Our accounting team needs to be able to track and accrue for work submitted, work rejected, and supposedly owed balance as of today.

[Ivan Tovbin]

Hi Chegg,

I think this can be done if you use this JQL for your filter:

status was in ("Under Review") or status = "Under Review"

For your "Rejected" and "Cancelled" statuses you'll have to set up separate filters using a similar JQL. 

[Chegg Coop]

Thanks Ivan! In the export of this filter, will it show who was assigned when the issue was "under review"? I'll need to be able to tie each issue status to a user.

[Ivan Tovbin]

Unfortunately not. It'll simply return all issues that ever had this status, but it won't show you who the issue was assigned to during that status.

[Chegg Coop]

Appreciate the follow up Ivan. Thanks!