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

[Deleted user]

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?

[Danut M _StonikByte_]

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. 

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]

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.

[Walter Buggenhout]

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]

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.

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

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.....

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