Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
This can be achieved in the script and you don't have to create a calculated dimension.
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?