The percentage are not consistent into across selections

[#1]

Hi All!!

I have a litle Issue.

I Have a data that is measeuring a subset of data against the total.

The formule its the following:

Count({<Resultado_llamada={'Atendida'}>}IDCALL) / Count(IDCALL)

beside this, i have other indicator with the following:

Count({<Resultado_llamada={'No Atendida'}>}IDCALL) / Count(IDCALL)

The Field Resultado_llamada have 5 posibles values.

What is happening. When i select any value, the result displayed its correct, but no the others indicators.

For instance:

If i select "Atendida", in the first indicator show me 100%. But, does not display 0% in the second indicator as spected.

Just to clarify the case, i'll put a table as example:

With no selections, the values are this:

Resultado_llamada	Total
Atendida	100
No Atendida	75
TOTAL	175

If i Select, for instance, "Atendida" the result is:

Resultado_llamada	Total
Atendida	100
No Atendida	75
TOTAL	100

The Spected result that i would like to receive, if i select "Atendida", is:

Resultado_llamada	Total
Atendida	100
No Atendida	0
TOTAL	100

Thanks for any feedback.

Regards!

[sridhar240784 · Accepted solution]

Not Sure whether i have understood you problem properly.

Try using below expression, this may help you.

Count({<Resultado_llamada *={'Atendida'}>}IDCALL) / Count(IDCALL)

Count({<Resultado_llamada *={'No Atendida'}>}IDCALL) / Count(IDCALL)

-Sridhar

[#3]

THANKS a LOT!!!  It works!!!

Regards!