Post reply

Median Processing time, Average Procesisng time for created/closed date

  • January 26, 2021 at 12:21 am

    #3837420

     

    We have sharepoint as the data source and we have 2 dates created date and closed date , we need to calculate average and median processing time for both .

     

    We are having an issue with following command :

    =Datediff("d",(FormatDateTime,First(Fields!Case_closed_date.value,),dateFormat.Shortdate),(Formatdatetime,First(Fields!created.value),DateFormat.Shortdate))

     

  • January 26, 2021 at 6:15 am

    #3837484

    So you create a statement on top of what you have and then get an average of the datediff results.

    AFAIK, you'd have to roll your own median function. I'm sure there are some out on the internet somewhere... the logic is a bit fun... if there are an even number of members in your set, get the middle two (after sorting) and average them. If there's an odd number, then get the middle one. you can do it by using TOP and OFFSET.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply