Hi,
can I find all issues for users of a certain group that have a single ‘timespent’ entry with more than 2 hours using eazyBI?
Thanks in advance
Hi @juemue,
It is possible. However, the implementation depends on the actual detailed requirement.
You might import Jira user groups to your eazyBI account. Please read more about that here - Data from Jira.
Generally, the spent hours are imported with worklogs and are available as aggregated values.
If you only want to see issues where users of a specific Jira user group have spent more than 2 hours, you might add the “Logged by Group” dimension to report pages.
Then, you might put the issue dimension to report rows and use the row filter to only display issues that have more than 2 hours logged.
Please read more about setting up row filters here - Row filter.
However, if you need the issues where individual registered worklog has exceeded 2 hours - that would require either iteration through the hidden Wroklogs dimension or a JavaScript-calculated customfield approach to identify these worklogs and issues already during the data import.
Unfortunately, the approach with iteration through individual worklogs might be slow and lead to report timeouts.
The approach with JavaScript might be similar to the option describes by colleague Zane here - Time Tracking Reports - number of time record - #2 by zane.baranovska.
Regards,
Oskars / support@eazyBI.com