Median duration with conditions

[Betty_sam]

Hi,

 I would like to calculate the median duration for d-1 excluding flag=0.

 I don't want to use the filter in the menu for the date and the flag.

Any help please ? 

Thanks in advance. 

[MarkusWeick]

Hi @Betty_sam,

could you please add some sample data and your VA version number?

Best

Markus

[Betty_sam]

Hi @MarkusWeick,

I am using SAS VA 8.5.2 , SAS VIYA 03.05

Here is some simple data : 

Thanks

[MarkusWeick]

Hi @Betty_sam,

another question: what do you mean with "d-1"?

Best

Markus

[Betty_sam]

today-1 , in this example it will be 08/06/2022

[MarkusWeick]

Hi @Betty_sam,

I had been workung with the Aggregated Operators in Calculated Items lately (though in VA 7.5) and hoped to find a solution using these. But it didn't work. Sorry!

Best Markus

[MarkusWeick · Accepted solution]

Hi @Betty_sam,

if you really just want to have the median for “today-1”, there is way:

You could create a calculated item, which contains values only for yesterdays durations with flag = 1:

(To get the "Missing" into the ELSE-cell you have to insert a dot ".")

For this column then you set the format to “elapsed time” and the aggregation to “median”:

With a list table with the new column as only column you get the following result:

Does this meet your requirements?

Best

Markus

[Betty_sam]

Hi @MarkusWeick,

Its working, thank you very much

Best regards