Project "Issues: 30 Day Summary" chart doesn't show new issues

Ryan Fisher1

On the project summary page, this chart is not showing newly created issues. It is also showing a period of multiple years not 30 days. I've attached a screen shot, not sure what I can do to fix this. I've re-indexed all issues.

Does anyone know where I can look to see what tables the chart is using to be generated? I'm assuming there is bad Data in the tables for this project, I have other projects where the chart is accurate.

Thanks.

Ryan Fisher1

I found the problem, it was bad data. When I imported my origional set of tickets the resolution date field was incorrectly formatted. This inserted resolution dates in the future for some tickets. I resolved this by setting jiradb.RESOLUTIONDATE = jiradb.UPDATED:

UPDATE jiraissue SET RESOLUTIONDATE = UPDATED WHERE RESOLUTIONDATE IS NOT NULL AND RESOLUTIONDATE > now() AND project = 10301;