how to calculate MEDIAN time to reply?

I let Excel do this for me. I pull my export, open it with Excel (or push it through to Power BI - in my case), clean up the date field (if needed) and then make use of the MEDIAN function.

Thanks, @bjoern_schulze. Which export are you using? 

In order to calculate the Time To Response, we pull the “Posts” export. (In our case we pull this table into Power BI, where we transform a lot of the columns and data to get more information and correlations out of it.)

In the export table you’ll find a column “time_since_previous_post”. This is basically the Time To Response. Now Excel should let you calculate the Median “time_since_previous_post”. If not, you might need to transform the data type first.
It gets more complex when you only want to know the Median TTR for your moderators, for example, as you have to filter by another column “userRole” first.

I haven’t done this in Excel myself, so take my advice with a grain of salt. Like I said, we do all of this in Power BI (and with the support of an external agency). But I hope that you can pull the basic Median TTR the way I outlined.

@bjoern_schulze ahhhh how I miss my Power BI days….

I appreciate the additional insights. 

One follow up: the Posts export has all replies on that thread and it seems all the time since previous posts are truly previous post on the thread, not since the original topic post. 

Do you know of how your team is limiting the analysis to the first reply?

@DannyPancratz did you ever figure out the isolation of first reply.

initial post is simple, blank time to previous post, but the FIRST reply ??

@Alistair FIeld our data engineering and analytics team was able to do this for me leveraging the REST API content data we ingest into snowflake and then visualize in Tableau.

I’ve never been able to calculate this using the out-of-the-box exports. It might be possible, but my excel skills aren’t that good