nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Report

Ayush Lawania

Need to create a report where I can see the issue count for status flipped in from one status to another.please help

Accepted answers

Alex Koxaras -Relational-

Hi @Ayush Lawania

In order to achieve this you have first to create the filters which will show the results you want.

E.g. if you want to see which issues changed from status A to status B, then you can write a JQL like: project = you_project_name and status CHANGED FROM "A" TO "B"
Save the above search as a filter
Repeat steps 1-2 to create your filters for your statuses
Go to an existing Dashboard > Edit (or create a new dashboard)
Add a gadget e.g. "Filter Counts"> Select a filter
Select the Status variable
Repeat steps 5-7 to add more for the other statuses

Keep in mind that you could also use Issue statistics or Two Dimensional Filter Statistics to get the same results.

Let me know if you got this!

All comments

Alex Koxaras -Relational-

Hi @Ayush Lawania

In order to achieve this you have first to create the filters which will show the results you want.

E.g. if you want to see which issues changed from status A to status B, then you can write a JQL like: project = you_project_name and status CHANGED FROM "A" TO "B"
Save the above search as a filter
Repeat steps 1-2 to create your filters for your statuses
Go to an existing Dashboard > Edit (or create a new dashboard)
Add a gadget e.g. "Filter Counts"> Select a filter
Select the Status variable
Repeat steps 5-7 to add more for the other statuses

Keep in mind that you could also use Issue statistics or Two Dimensional Filter Statistics to get the same results.

Let me know if you got this!

Ayush Lawania

Is there any other way to achieve this, also I am using easybi reporting extension in jira, if you could help me out with that as well then it would be really helpful.

Alex Koxaras -Relational-

Unfortunately I don't have eazyBI but you can start by reading their documentation here https://docs.eazybi.com/eazybi?eazybi-for-jira This ought to help you accomplish what you want!

Ayush Lawania

I tried using the steps which you mentioned above but it seems to be not working, i created the jql query for to do to in progress status but it shows completed status as well...jql used was: project= "Integration- Marketing" and status changed FROM "TO DO" TO "IN PROGRESS"

Ilze Leite-Apine - eazyBI

Hi @Ayush Lawania

Here is Ilze from eazyBI. As you have eazyBI, you my create a report there.

For that,

use measure "Transition to status issues count" together with "Transition Status" dimension (expand to statuses) in the report columns;
add some dimension in rows (Project or Issue type would work, the data for totals will be the same);
add Time dimension in Pages for filtering by a period when transitions happened. Select calculated member "Today" or "Yesterday" to always show issues with transitions to statuses for that day.

See how the final report table would look (I used "Current year" as Time period because I do not have good data for "Today"):

If you have the "Issue type" dimension in rows, you can expand it to show numbers by issue type.

If you want to show only numbers without table, switch from Table to Gauge and select the option "Only values".

Hope this report answers your questions!

Best,

Ilze, support@eazybi.com

Ayush Lawania

Am not able to see the images which you have attached here, can you please attach them again.

Ilze Leite-Apine - eazyBI

Hi, I am sorry for that!

Below is the initial table report:

Table report.png

This is the same report, Gauge chart view, with the "Only values" option selected:

Gauge report.png

Are they visible now?

Ilze

Ayush Lawania

Does this update on daily basis?

Valeriia_Havrylenko_SaaSJet

Hello @Ayush Lawania

As an alternative , I guess you can try Time in Status for Jira Cloud (developed by my SaaSJet team) with 7 types of status time reports can help you with this.

All your information about time that your team spent working on tickets in specific verticals during the year will be show up here.

For example

Status Count,
Transition Count

GIF TIS.gif

This add-on has a 30-day free trial version.
Please, let me know if you have any questions

Hope it helps,
Valeriia

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-software

jira-software-cloud