Pie chart (or table) that shows time spent by the assignees yesterday

Question

Hi Guys,

I want to create a pie chart (or a very clean table) to show the time spent/logged by the assignees yesterday

I tried to use a Workload Pie Chart Report, but it will show the time spent from first day of the project.

You can use a filter, but i could not find a way to create a filter that sets the time period

Any idea?

Thanks!

Vibs Agrawal · Answer

You can edit the query in the filter by using JQL similar to below:

status changed to DONE after startOfDay() -1 OR status changed to "IN PROGRESS" after startOfDay() -1

Midori · Answer

Better Excel Plugin has an export template called worklog-analysis.xlsx that exports worklogs to an Excel sheets and does configurable multi-dimensional analysis on them.

You could easily modify that to your needs:

* Use a pivot table with a single dimension (worklog author)* Consider using a secondary dimension for issue key or project key if you need "more resolution" in your reports

* Use a pivot chart (pie format) for the visualization
* Introducing the extra filtering logic for "only process the worklogs from yesterday" either in Excel or in Groovy

Jobin Kuruvilla [Adaptavist] · Answer

Not possible out of the box. Filter will always get you the latest information, although you can search for issues updated/created yesterday and so on. The data it returns will be current.