How to use a calculated dimension to force chart to only look at pre selected value

[Anonymous]

I have a field called disability.  I wantto force a chart to only look at a particular type of disability.  Do I use a calculated dimension to do this and what would the expression look like?

Thanks

Greg

[Gysbert_Wassenaar · Accepted solution]

You're probably better of using a set analysis expression. For example if your chart uses the expression sum(Amount) you can change that to sum({<MyDisabilityField={'Legless'}>}Amount) to filter out any records that don't have Legless as value in the field MyDisabilityField.

If you think you do need a calculated dimension you can use something like =if(MyDisabilityField='Legless', MyDisabilityField) and make sure to suppress null values for the calculated dimension.

[Anonymous]

Thanks very much

[alexandros17]

in the calculated dimension write:

If(disability = 'myDisability', disability, Null())

where myDisability is the value you want to fix

then check the box "Suppress when value is null"