JIRA Filter on Worklogs

[Jo Steele]

I hope someone can help me as this is really doing my head in. I am setting up a dashboard and I want to show time spent on projects for a certain time period, exclude a certain project (internal tasks) and display by project.

Tempo worklog distribution gadget works OK, I can easily pickup the current time period set in tempo and group by project. However I can only display as much as the last 90 days. I need to show two pies: 1. with current period and 2. with last 12mths data

If I use a Workload Pie Chart gadget and use a filter for current period data, I am entering:

Project not in ("Internal tasks") AND timespent is not EMPTY AND worklogDate >= "2018-06-24" and worklogDate <= "2018-07-23"

What am I getting wrong? Whenever I try to use a Jira filter to get the data it always give me extra data and I don't get it!

[Walter Buggenhout]

Hi @Jo Steele,

The reason is that your JQL filter returns a list of issues, not worklogs. Even though you are using worklogdate as criteria, the result is still just the set of issues that has worklogs against them during the specified period. But some of those issues will also have worklogs outside that period, and that's what you see in your dashboard.

You can get to the data you describe in Tempo Timesheets as follows:

• Save the JQL filter above (you can leave the 'timespent is not empty' part out btw), e.g. as 'Filter for workload by project report'.
• Navigate to Tempo / Timesheets
• In the top left corner, select 'Advanced' as your timesheet type and then locate your saved filter as data source
• In the top right corner, select 'Report' as your view option.
• Right below that, set the 'Rows' option to Projects

You will get something like this, where your can see the hours per project:

It is not a nice graphical representation, but you have the data at your fingertips here. You could even leave out the time dimension from your JQL, as you specify the time range right here in your report.

If it is really crucial to get the data on a dashboard, I would recommend having a look at more powerful reporting tools, like EazyBI.

[Jo Steele]

Thanks Walter, that sheds some light. I really need a dashboard view for senior management to get a snapshot of our business. Team dashboards I can make due with Tempo gadgets. But senior leaders need much broader info. We are a finance business and love a good data table and spreadsheet but for this I need charts.

I trialled EazyBi but that was from a reporting perspective when it was all pear-shape with Tempo a year ago and I couldn't produce our monthly billing report due to Atlassian/Tempo changes.

Any other recommendations for dashboard/reporting addons?