PROBLEM TO CALCULATE MEDIA, MEDIANA AND DEV STD

[gabroteddy]

When i have a lot of data i must take the Media, Mediana and Standard

Deviation of all case.

I attach the dashboard that i have in output.

What i want do is calculate the media, mediana and devstd of only the ID

where the interval is correctly calculate (sometime is not valorized)...if

is possible in a separate dashboard.

Solutions???

[balabhaskarqlik]

Median & Std Dev calculation may be like this:

=Median({<[Patient Test] = {'Test1', 'test2'}>}

        Aggr(Count({<TestList = {'Test1', 'Test2'} >} PatientNumber),PatientNumbea)

       )

=Stdev(aggr(sum(Revenue),Desk, Day))

OR

=Stdev(Aggr(Sum([LV_M-Abgang-Gesamt]), Division, Lagerort, Artikelgruppe, [LV_JahrMonat/YearMonth]))

[gabroteddy]

Hi Bala,

can you explain better the formula?

I do not understand what information i must utilize....can you utililze th field present in my dashboard to explain me how i can compile the formula?

Thx

[balabhaskarqlik]

Think so some thing like this:

=Median({<PROVA1_ORA=,PROVA2_ORA=>}

        Aggr(Count({<PROVA1_ORA=,PROVA2_ORA=>}ID),PROVA2_DATA,PROVA1_DATA)  

        )

=Stdev(Aggr(Sum(PROVA1_ORA),ID,PROVA1_DATA)) + Stdev(Aggr(Sum(PROVA2_ORA),ID,PROVA2_DATA))