Why you shouldn't count First Response Time (FRT) by hand using daily medians

Written by Konstantine

Updated 2 weeks ago

Let’s say you load the report for the last week. The FRT tab (First response time) shows you a value of 2 minutes.

Then you look at the chart in that same report. It shows median values for each day. Let's say it's:

Day 1 – 5 min
Day 2 – 3 min
Day 3 – 1 min
Day 4 – 6 min
Day 5 – 1 min
Day 6 – 3 min
Day 7 – 0 minutes

If you arrange them in ascending order:

0, 1, 1, 3, 3, 5, 6

The median of these daily medians is 3 minutes.

But that’s not how the report calculates the weekly FRT. The value of 2 minutes shown in the tab is based on all chats from the entire week, not just the daily summaries. It sorts the FRT values of every chat in that time range and then takes the true median of that full dataset.

In contrast, the chart aggregates per period (hour/day/week/month), depending on the selected range. So what you see on the chart is the median of a specific slice, not the full period.

So, calculating a median of median values by hand will always misrepresent the actual result. It's like comparing the summary of summaries to the actual raw data.

More examples:

Example 1: Skewed data distribution

Let’s say on one day, you had only 2 chats:

Chat 1 – 1 min
Chat 2 – 20 min

The daily median would be (1 + 20)/2 = 10.5 minutes
But on another day, you had 100 chats, all answered in 2 minutes. The daily median would be 2 minutes.

Now if you average or recalculate the weekly median based on these daily medians:

Day 1 (few chats): 10.5 minutes
Day 2 (many chats): 2 minutes

You would end up with a misleading median of 6.25 minutes, even though most chats were fast. The high outlier from a low-volume day distorts the picture.

Example 2: Inconsistent chat volume per day

Day 1 – 100 chats, median: 2 min
Day 2 – 5 chats, median: 6 min
Day 3 – 80 chats, median: 1.5 min

Trying to calculate a median from daily medians without weighting by volume ignores the fact that Day 1 and 3 had way more data. It gives equal weight to Day 2, which had very few chats but a higher median. That’s how false impressions form.

Are deleted chats counted in FRT metrics or not?

When displaying the value in the FRT (First Response Time) tab, it's generated based on the data available at the moment - deleted chats are excluded from this calculation.
However, if you look at the summarized bars in the chart, those do include deleted chats. This can lead to small discrepancies between the chart and the FRT tab, especially if chats were deleted after the period passed but before the report was viewed.

In summary:

The FRT tab uses all raw chat data to calculate a true median for the selected time range.
The chart shows periodic medians, helpful for spotting trends - but not suitable for manual averaging or comparison with the tab’s value.

Did this answer your question?