Dimension should not be filtered based on selection

[nithin_miryala]

Hi Everyone,

I have a chart which has 5 Cpt's it when i do not select nothing, but when i select a provider it narows down to 3 of them,

I want the Dimension to have 5 even if select the any provider

Here is the expression: = aggr(Only({<EMVisitTypeDSC={'NPV'},Provider=>}CPT),CPT)

Let me know your thoughts

[sunny_talwar]

What if you try this

Aggr(Only({1<EMVisitTypeDSC={'NPV'}>} CPT), CPT)

[nithin_miryala]

Tried it. it still filters the CPT

[sunny_talwar]

This is used a dimension, right?

[nithin_miryala]

Yes

[sunny_talwar]

Would you be able to share a sample to show where this isn't working? I don't see anything wrong with the syntax

[krishna_2644]

Aggr(Only({1<EMVisitTypeDSC={'NPV'},Provider=>} CPT), CPT)

[nithin_miryala]

Please find the attached sample.

Please look at it

[sunny_talwar]

I think you forgot to ignore selection in the expression

=sum({<EMVisitTypeDSC={'NPV'}, ProviderNBR>}EMVisitCNT)/

sum({<EMVisitTypeDSC={'NPV'}, ProviderNBR>}TOTAL EMVisitCNT)

[nithin_miryala]

I did it intentionally as i want to show zero on the that particular CPT.

and i should be able filter graph but not the number CPTs in the dimension.

is that possible?