Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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???
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]))
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
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))