Jordan Means

In the new beta dashboard builder, it is very easy to accidentally delete an entire dashboard because the button to delete the dashboard is in the exact same location as to remove a report when the report data is expanded.

This is what deleting a report looks like:

This would delete the whole dashboard:

 

For comparison, this is how you would delete a dashboard in the old dashboard builder:

 

The dashboard options should really be moved to the left side or be visually more different. I have deleted a dashboard multiple times from muscle-memory since the actions are so similar.

I have been trying to build a report where it returns the timestamp that a ticket was first set to pending or on-hold but something isn't right as I am getting null values for some tickets that did have that change happen. The numbers that do get returned appear accurate. This may or may not include other changes in the same update, which I don't care about checking.

My calculated attribute is Update to Pending/On-Hold.

IF ([Changes - Field name]="status"    
       AND ([Changes - Previous value]="open" OR [Changes - Previous value]="new")
        AND ([Changes - New value]="pending" OR [Changes - New value]="on-hold" OR [Changes - New value]="solved")
       AND DATE_FIRST_FIX([Update - Timestamp],[Update ticket ID],[Changes - Field name],[Changes - Previous value],[Changes - New value])=[Update - Timestamp])
THEN [Update - Timestamp]
ENDIF

Then I am plugging that into a calculated metric:

DATE_DIFF([Update to Pending/On-Hold],[Ticket created - Timestamp],"nb_of_minutes")

I suspect there is something off about the DATE_FIRST_FIX and have tried changing the values there but most combinations lead to nothing at all being returned. Is something causing it to be unable to detect the first change in some cases?

I am trying to create a metric that computes the difference between when a ticket is opened and the first time it goes Pending or On-Hold. First Reply Time and Time Pending don't fit that need.

Any advice on how you'd create this?