Filter for dashboard

Question

Hi all,

i try to developpe a dashboard and i have difficulty to creat a filter for displaying the total of ticket open by me for spedcifique user in a sprint or since since a specific date ( january first) for exemple.

sombody know how to process for this kind of dashboard and wath is the better gadget for displaying that.

thank

sebastienlaramee · Answer

thank for the answer. I will try that.

somethingblue · Answer

Hi Sebastian,

What query are you using and what is it returning.  I would start out with something like the following:

reporter = admin and assignee = testUser and (sprint = 3 OR createdDate < startOfWeek())

That should get the issues you opened and assigned to that person if it's in a specific sprint or opened before a certain date.  Take a look at the Advanced searching - functions reference for more information on how to narrow down days in JQL.

Cheers,

Branden