The Solved date in Explore is the last solved date. I'm looking for the first solved date, which I figure is somewhere because there is a metric for First Resolution Time.
I tried to build the an attribute with the following function, but it appears to not work because VALUE(First resolution time (days)) is NULL or zero for all the rows in my table.
Here is the function I created: DATE_ADD([Ticket created - Date],"day",ROUND(VALUE(First resolution time (days))))
I believe the problem is the last parameter, but does anyone know why? Is there a way to get this information?
Please sign in to leave a comment.