Graph not plotting the Sum of existing issues

[Prathima Ramachandra]

Hi,

‌

I am trying to create a graph that shows me the trend of issues created / resolved / and currently open for a particular label. All the different created / resolved line graphs are getting plotted correctly. But the Total open items when I select the Time series as None(Sum of existing issues) gives me 0 as the count. I have tried to play with query in different ways, but not able to get the same. What is it that I am doing wrong here? The dashboard where I am trying this out is: https://eton-solutions.atlassian.net/secure/Dashboard.jspa?selectPageId=10188#JavaScript-Chart-for-JIRA-Cloud/10893

‌

This is urgent & if any help can be extended today, that would be great.

Prathima

[Prathima Ramachandra]

This query that I have used: labels = CSOPBug and resolution = unresolved has an output of 71 issues. So it isnt related to Performance either. There seems to be something else broken.

[Prathima Ramachandra]

Followed what is given in your tutorial https://bitbucket.org/dboyd-atl/javascript-charts-for-jira-cloud/wiki/tutorial3

But the moment I select Sum of all issues, the result is 0. Tried different params within, like Issue count, Days created, Story Point etc, but the graph remains at 0.

[boydo]

Hi @{5d43eab3982c2b0db298b55d}

The JQL query when using “Sum of all issues” requires a “WAS” in it. It is executing that query during a time period in the past.
So to show the trend of unresolved queries over time, you would need something like:
labels = CSOPBug and resolution WAS IN ('unresolved')

[Prathima Ramachandra]

Hi boydo, I used this, but it throws me 0 issues. and hence the graph remains at 0.

However I used alternate way of querying the data and got this working. Thanks..

[Prathima Ramachandra]

Suggestion worked for me.