I am trying to get difference in days between first contact and close date.
below is the calculated field:
DATEDIFF('day',DATE([First Contact Date]),DATE([Case closed date]))
Case closed date = IF ISNULL([Closed Date]) THEN TODAY()
ELSE [Closed Date]
END
Results attached
답변 2개
good morning @Michael Madisha - the function datediff is being calculated at the record level and then it is aggregated over the number of records -- the difference is 362 days but there must be 2 records so the aggregation is 726 - you need to aggregate using avg(), Min(), Max() or some other appropriate aggregation
