Creating custom filter

Pete Piro

Hello,

I want to create a custom filter of support issues for multiple machines for a dashboard...

When a ticket is created, the customer is presented with 5 pulldown menus on the Request Form (for simplicity Ford, GM, Toyota, Nissan, Honda), and within each menu, we have various models (Ford - Mustang, Explorer, F150, Ranger, etc) 

I know how to create filters for each make (Ford) to know how many issues were per model but I want to show how many tickets were created per make over a period of X weeks... 

At the end, what I'm looking for is a filter where I can use a 2D Dashboard filter to display ticket Status on the X-axis and Make of the machines on the Y-axis.

Thank you, Pete

Jimmy Seddon

Hi @Pete Piro,

You are going to want to setup a JQL filter something like this:

'make = Ford AND createdDate > -2w' 

That will display all "Ford" tickets created in the last 2 weeks.

Or something like:

'make = GM AND createdDate >= startofMonth("-1") AND createdDate <= endofMonth(-1)'

which will give you all GM tickets created between the start and end of last month.

You can find more of the date functions to experiment with here:

https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-functions/

I hope that helps!

-Jimmy