Calculate Median

[#1]

Hello all,

I am having hard time to calculate median time using expressions. I need to put some specific criteria in place for getting my median value.

Here is what I am trying to do:

Referral id        *RFI date      *RFI Response Date        RFI date – RFI Response                  SUM

101                  Mar 10        Mar11                                              1                                     1

102                  Feb 5          Feb 7                                               2                                 

102                  Apr 3          Apr 5                                                2                                     4

104                  Jun 4          Jun 7                                                3                                     3

At the end median = {1,3,4}=3

* RFI date: Request for information

* RFI Response Date: Information sent back

Based on this example I get number of days between RFI Date and RFI Response Date and I get sum of these dayes per referral.

My problem is I don't know how to calculate the SUM group by referrals as an expression without changing the data model.

I appreciate if you share your exprience on that.

Thank you,

Behnaz

[mehmet_caldak]

Hi Behnaz,

create a pivot table then add a calculated dimension just after Referral id column. The calculated dimension should be like that;

Aggr(Sum(RFI date - RFI response),Referral id)

i hope this solve your issue.