How to filter issues wihout solved or done issues on dashboard?

[Snehal Metkari]

I want to see only open and in progress issues in filter on dashboard. I don't want done and resolved issues.

For e.g If i choose Pie chart filter or two dimension filter there should be only open and in progress issues count/total not included done or resolved issue.

Is it possible?

Could you assist me please?

Thanks,

Snehal

[Jack Brickey · Accepted solution]

Hi @Snehal Metkari , welcome to the community.

you can create a filter that can be associated to your gadgets. Here is an example...

project = abc and statuscategory != done

[Snehal Metkari]

Hi!

Thank you for your quick response.

I tried to do this but whwn i click on advanced search button there is showing this window which is i am attaching here.

Where can write JQL query? I mean this "project = abc and statuscategory != done"

[Jack Brickey]

>>>>> edited to remove misplaced response <<<< 

do this...

1. Click into the search bar in the top menu
2. click on advanced search issue
3. ensure you are in the Advanced view
4. create an save your filter
5. in the dashboard associate your filter to your gadgets

[Tansu Akdeniz]

Hi @Snehal Metkari 

Welcome to the community.

You should first save your search as a filter. Sample jql: resolution is EMPTY

Then give this filter as an input to gadgets.

[Marta Woźniak-Semeniuk]

Hey @Snehal Metkari 

Create first a filter you wan to base Pie-chart or 2dimensional filter on - use the filter you have for your project but add 

AND status in ("Open", "In Progress")

Then save the filter with and use it for the gadgets on dashboard

[Snehal Metkari]

Hello!

Thanks to all of you for your answer, it's very helpful for me.

I got the solution and my issue is resolved.

Thank you so much once again.