Calculating Response Time

[ATester]

Hi there,

I have a spreadsheet that I have added to the Data Module and I have two columns (Creation Date and Closed Date). I added another column for Response Time (which should be the difference between the two columns). What formula do I need to put in the Data Model? Do I put the formula in the Data Model or should it go on the sheet itself?

 

[scottsen]

On the table, in the data model, you can add a calculated column, which will look something like
=MyTable[Closed Date] - MyTable[Creation Date]

 

[ATester]

On the table, in the data model, you can add a calculated column, which will look something like
=MyTable[Closed Date] - MyTable[Creation Date]

Thanks.

Is there a particular power view chart that would best display this information?

 

[scottsen]

I like to avoid power view, cuz I'm ... well, I'm anti power view

Regardless, it would help to know what you hope to show. eg: Are you going to add a Calendar table, relate it to the above table, then show Average Response Time per Month?

 

[ATester]

I like to avoid power view, cuz I'm ... well, I'm anti power view

Regardless, it would help to know what you hope to show. eg: Are you going to add a Calendar table, relate it to the above table, then show Average Response Time per Month?

Yes, I just want to show the average response time within a set period. (monthly or weekly)

 

[ATester]

The answer is a decimal. Is that the number of days or hours or seconds in between ?
My start and end date columns are formatted as

3/13/2014 4:53:15 PM

<tbody>
</tbody>

 

[scottsen]

The result of subtracting two dates is a number of days. So in the same day, 3pm-2pm is 1/24.