No of tickets are not commented 5 days ago

How to find the results

No of tickets are not commented 5 days ago

@Thangavel_VELUCHAMY

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