How to show multiple filter results on one chart?

I have a filter showing issues with resolve date > due date and I need to show on chart how many percent of all issues is overdued. Seems it should be seemingly easy but I couldn't find a way to achieve it. Does anyone know if it is possible to get such result somehow? Any help would be appreciated.

1 answer

0 votes

Create a filter that duplicates the other two, but merged together.  Simplest way is a bracketed OR:

(filter definition 1) or (filter definition 2)

 

Thank you for quick answer, but I'm still not sure how to get overdued issues percentage from these merged filters and show it on chart. Thank you in advance for any advise.

I have added scripted field to check and mark an issue if it is overdued but this field is not available in Statistics Type in reports. I know that text fields and other uncountable fields are not available in Statistics Type but what about custom fields like scripted field or calculated field. My scripted field can only get Yes or No, so it should be easy to use this information in report or on chart. Is there any way to achieve this?

Not with a scripted field.

If you add a standard custom field you can do it.  Use a scripted listener to pick up any event that might change your current scripted field and run the same calculation you're doing in the scripted field to populate that custom field.

Thank you for advise, Nick. My scripted field is based on simple if (issue.resolutionDate > issue.dueDate) then return “Yes”, else “No”. But I couldn’t manage to figure out how to use script listener to make it work. Could you be so kind and give more detailed explanation how to make it work, with some script example? Thank you in advance.

I have this bookmarked as a bit of code to "update a field in a listener"  https://answers.atlassian.com/questions/38830904

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

2,754 views 11 18
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot