Forums

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

Can you limit the ime period of a pie chart report?

Eric Leach November 21, 2018

When I run the Jira Pie Chart report it appears that the data displayed to cumulative and represents all data ever entered. Is there a way to limit the data reported to just the last 30 days or to a specific date range like 11/1/2018 ro 11/30/2018?

1 answer

2 votes
Jack Brickey
Community Champion
November 21, 2018

you cannot do this dynamically, i.e. w/in the gadget but you can certainly change the filter to restrict the period of interest.

Eric Leach November 21, 2018

Sorry, this is probably a dumb question, but how do I change the filter for time, when I click on the change filter link I don't see any time period option?

 

Jira.png

Jack Brickey
Community Champion
November 21, 2018

wait...sorry i think you are looking at some default report maybe. Can you elaborate on where you are seeing this and Server or Cloud?

I immediately thought that you were using pie chart gadget on a dashboard for which there is an underlying filter that you can edit. 

still might be possible. i just need more info here to assist further. but if this is something Server specific I may run out of ideas as I use Cloud.

Eric Leach November 26, 2018

This is the default pie chart report in the cloud version of Jira

Jack Brickey
Community Champion
November 26, 2018

@Eric Leach, can you create a filter and save/star it that includes the time frame desired. Then select under the "Starred" tab in your Filter or Project Picker.

Eric Leach November 27, 2018

Probably, except I have no idea how to create a filter.....

Jack Brickey
Community Champion
November 27, 2018

ok so first here is a link that you should read - advanced-searching-functions-reference as filters and searching are all too important in Jira. Note to that you can search for tons of info w/in the documentation from that link.

Quick starter: (assumes you are on Cloud)

  1. click magnifying glass and view all issues
  2. in the search bar above the list enter the JQL that represents the issue query that meets your needs. For example: project = abc and createdDate >= startOfMonth(). You can also use exact dates if you like. Once you start typing the auto-complete helps by giving you valid options in most cases.
  3. once you have the search the way you want it click the Save as and give it a name.
  4. Now you can create a dashboard w/ pie chart gadget and use the saved filter. Be sure to share the filter and dashboard if you want others to see it.
Like # people like this
Eric Leach November 28, 2018

You are the man! Thanks, one last question, looking at the syntax for the JQL functions I didn't see a way to specify a specific month, like October or November?

 

project = "IT Infrastructure KanBan" AND createdDate >= startOfMonth() AND createdDate <= endOfMonth()

Eric Leach November 28, 2018

Never mind, I got it, Thanks for your HELP!!!!!!!

Jack Brickey
Community Champion
November 28, 2018

Great! If this all helped please consider accepting the answer to close it out.

Like Diego Valle-Comin likes this

Suggest an answer

Log in or Sign up to answer