I would like to create a chart of the time spent after a certain date. when I run this filterissueFunction in workLogged("after 2013/5/1") I get the issues that have time logged to them after that date. But the time spent column is an aggregation of all work logged to the issue.Is there any way to get the aggregation of time spent after a certian date
I think that you have problem because source for your chart are issues (with all worklogs) not worklogs (with relating issuses).
Link to SQL query to get Workflow data for reporting:
https://confluence.atlassian.com/display/JIRACOM/Example+SQL+queries+for+JIRA#ExampleSQLqueriesforJIRA-GetWorklogdataforreporting
It looks like you're new here. Sign in or register to get started.