I've recently added a Custom date field to one of my forms and want to calculate the difference between the that date and today's date. I used the same formula as the Unsolved ticket age formula:
DATE_DIFF(TODAY(), [Complaint Received at - Date], "nb_of_days")
but I'm getting seriously weird results.
If I just put the metrics down, I seem to get the right info. But as soon as I try slice it by attributes it doesn't make sense. If I try sense check by slicing by ticket ID I either get an error asking me to try narrow down my query or I see ticket IDs from years ago (keep in mind I've just added this field and it should apply to sub 200 tickets).
I also sometimes get the following error:
An error has occurred while evaluating AVG(Unresolved Complaint Age (days)) for the following values: Complaint Received at - Date -> .
Anyone have any ideas on whats going wrong and how to resolve it?
댓글을 남기려면 로그인하세요.