This content has been marked as final.
Show 4 replies
-
Re: Calculate Median from grouped data
Gysbert Wassenaar Aug 17, 2016 2:54 AM (in response to Joerg Linder)Perhaps simply median([Sales per prescripton line])
-
Re: Calculate Median from grouped data
Joerg Linder Aug 17, 2016 2:57 AM (in response to Gysbert Wassenaar )Thank you for your answer. I have already done that and got the median for prescription line but how do I obtain the median for prescription and patient?
Jörg
-
Re: Calculate Median from grouped data
Gysbert Wassenaar Aug 17, 2016 3:16 AM (in response to Joerg Linder)I don't understand what you want. Perhaps one of these three is what you're looking for:
- median(aggr(sum([Sales per prescripton line]),[Patient ID]))
- median(aggr(sum([Sales per prescripton line]),[Unique Prescription ID]))
- median(aggr(sum([Sales per prescripton line]),[Patient ID],[Unique Prescription ID]))
-
Re: Calculate Median from grouped data
Joerg Linder Aug 17, 2016 5:24 AM (in response to Gysbert Wassenaar )Hi Gysbert,
Sorry for not explaining it properly but you actually gave me the looked for answer.
Well done, thank you
Jörg
-
logo.png 3.6 K
-
-
-