How to find the results
No of tickets are not commented 5 days ago
How to find the results
No of tickets are not commented 5 days ago
In this use case, you can import “Comment last date” field from first (see similar case here: New Report - No comment for x days)
Make sure you import the field as property and measure from the import options page:
https://docs.eazybi.com/eazybi/data-import/data-from-jira
Then you can create a new user-defined calculated measure that counts the number of issues where the last comment hasn’t happened within the last 5 days (if I understand your requirement correctly).
(
[Measures].[Issues created] --all issues created and imported in eazyBI
)
-
--issues with last comment in 5 days
Sum(
[Time].[Day].DateMembersBetween('30 days ago', 'today'),
[Issues with last comment date]
)
Martins / eazyBI