Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

How to show multiple filter results on one chart?

John Locke January 30, 2017

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
Nic Brough -Adaptavist-
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.
January 30, 2017

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

(filter definition 1) or (filter definition 2)

 

John Locke January 31, 2017

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.

John Locke January 31, 2017

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?

Nic Brough -Adaptavist-
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.
February 2, 2017

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.

John Locke February 6, 2017

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.

Nic Brough -Adaptavist-
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.
March 3, 2017

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 Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events