topic Re: Median duration with conditions in SAS Visual Analytics

Median duration with conditions

Betty_sam — Thu, 09 Jun 2022 09:45:36 GMT

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.

Re: Median duration with conditions

MarkusWeick — Thu, 09 Jun 2022 09:56:55 GMT

Hi @Betty_sam,

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

Best

Markus

Re: Median duration with conditions

Betty_sam — Thu, 09 Jun 2022 12:34:00 GMT

Hi @MarkusWeick,

I am using SAS VA 8.5.2 , SAS VIYA 03.05

Here is some simple data :

Thanks

Re: Median duration with conditions

MarkusWeick — Thu, 09 Jun 2022 12:42:39 GMT

Hi @Betty_sam,

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

Best

Markus

Re: Median duration with conditions

Betty_sam — Thu, 09 Jun 2022 12:48:57 GMT

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

Re: Median duration with conditions

MarkusWeick — Thu, 09 Jun 2022 14:12:25 GMT

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

Re: Median duration with conditions

MarkusWeick — Fri, 10 Jun 2022 07:19:30 GMT

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

Re: Median duration with conditions

Betty_sam — Fri, 10 Jun 2022 07:58:22 GMT

Hi @MarkusWeick,

Its working, thank you very much

Best regards