Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
alejortizp
Contributor III
Contributor III

how can I create a dimension in which I choose the pacients by percentile?

Hi,

Im trying to make a dimension that identify the percentile that i want for later make a filter. i just rank my patient but i could not identify his percentile.

rank(Aggr(sum([Autorizaciones.COSTO_SERVICIO]), [CONTRATO_AFIL]))

this sentences doesnt work just put 0.5%:

if(rank(Aggr(sum([Autorizaciones.COSTO_SERVICIO]), [CONTRATO_AFIL]))*.0105<rank(Aggr(sum([Autorizaciones.COSTO_SERVICIO]), [CONTRATO_AFIL])),'0.5%','otros')

Thanks

Labels (1)
2 Replies
sibusiso90
Creator III
Creator III

This can be achieved in the script and you don't have to create a calculated dimension.

alejortizp
Contributor III
Contributor III
Author

Hi,

I have this code "num(rank(Aggr(sum([Autorizaciones.COSTO_SERVICIO]), [CONTRATO_AFIL])))/num(rank(Aggr(sum(total [Autorizaciones.COSTO_SERVICIO]), [CONTRATO_AFIL])))" .

This code tell me where is the accumulated of patients for know where is de percentile of this patients. But i want to filter for the 1% or 0.5% or 5% or 10% of this patients and not to filter manually. How i can do that?