question about DURING(X,Y) for creating a cumulative count graph of type of issues in Dashboard

Deleted user April 3, 2024

Hello All,

I used the "JAVA Script Chart for Jira Cloud" for cumulative graph.

I am also facing same issue(ref: https://community.atlassian.com/t5/Jira-Software-questions/Creating-a-cumulative-count-graph-of-type-of-issues-in-Dashboard/qaq-p/1640245) but follow guidance @Earl McCutcheon , cumulative graph can be created, but it is not what I want because it seem time filed in DURING (X,Y) is created time for each ticket.

Currently I want to replace the created time with registry time. Does X, Y in DURING(X,Y) can be defined to registry time? if so, what should I define?
Pic2.png

 

2 answers

0 votes
Danut M _StonikByte_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 4, 2024

Hi @[deleted],

Try the Cumulative Flow Diagram Chart offered by our Great Gadgets app.

It can calculate by issue count or by any numerical field and allows you to set a time range. It offers various options for grouping data,  so it might solve your problem. 

image.png

See more in this article: https://community.atlassian.com/t5/App-Central/How-to-track-scaled-agile-SAFe-projects-in-Jira-with-Great/ba-p/1929694

The app has a free trial of 1 month.

Hope this helps. If you have any questions, please contact support@stonikbyte.com.

Danut

Deleted user April 15, 2024

Thank you @Danut M _StonikByte_ 

I can not download the app which is not allowed by company, thank you for sharing and hope it will be helpful in near future.

I find another function named Time Since Chart which can realize cumulative count graph, for who are in same problem for reference.

0 votes
Walter Buggenhout
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
April 3, 2024

Hi @[deleted] and welcome to the Community!

While I am not really familiar with this marketplace app, I do know a thing or two about JQL. I am not entirely sure if I understand your question correctly, but my guess is you are trying to limit your selection to the dates when work was logged against issues.

If that assumption is correct, you will unfortunately run into the problem that JQL always returns issues, not time spent. You can use worklogdate as a keyword to limit the set of issues returned by JQL, but you will still get all the workflogs on those issues returned, even if they were logged before or after the given date(s).

As an example:

worklogdate >= "2024-01-01" AND worklogdate <= "2024-03-31"

will return all issues with worklogs on any date in January, February or March. But if those same issues also have worklogs on earlier or later dates, these worklogs will still be returned as well, because they are also attaached to those issues.

Hope this helps!

Deleted user April 4, 2024

Hi @Walter Buggenhout Thank you for your answer, your guess is what exactly I want to do. 

I tried to use the JQL provided by you, but there is error related to DURING() occurs as below I highlighted in green.

2.png

Actually I want to use registry data filed (highlighted in green as below) where I filled in the time that issue happened,

1.png

 

I also tried to use registry data filed to limit selection to the dates, but it is still not work, "WAS" is one of operators can support DURING(), and I think the function DURING() seems decide to using created time.....

4.png

 I am newer for JQL, wondering is any other method to create cumulative graph with registry time?

 

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events