I am fetching “Reply Time (avg)” Metric from Core Front API on weekly basis.
The problem I'm encountering is that when there are no replies sent on a particular day, the reply time for that day is recorded as 0. However, when calculating the average weekly reply time, I don't want to include these 0 values if there are no replies on that day. How can I retrieve this metric accordingly?
Because of 0s the “Reply Time (avg)” is getting significantly lowered.
I'm open to alternative methodologies/approaches to address this issue.