Custom attribute is throwing this error in the query:
Query failed to be executed on database. (ERROR: each UNION query must have the same number of columns Position: 582) (Error code: ad862ed4)
Custom attribute details:
We created a custom field attribute "Date First Solved" for a ticket and is pulling the correct data in the query. Adding the attribute as row, column or filter is throwing the error message.
Custom Metrics Utilized:
IF (VALUE(First resolution time (min))!=NULL AND VALUE(First resolution time (min))>0 )
THEN DATE_FORMAT(DATE_FROM_TIMESTAMP(NUMBER(DATE_TO_TIMESTAMP([Ticket created - Timestamp]))+VALUE(First resolution time (min))*60),"YYYY-MM-dd HH:mm:ss")
Vous devez vous connecter pour laisser un commentaire.