How to limit dimension values in the striaght table

[Anonymous]

Hi,

     I have a column District with many dstrict Id's in it.How to use this clumn as a dimension in a straight table by limiting only some particular id's??

[datanibbler]

Hi Tejaswini,

how do you know which IDs to limit the chart to? Is that information in some list? Is it dynamic?

You can use any IF_expression in the dimensions to use for your chart - but doing that takes away some choice from the user insofar as you pre-select the data for them. That might be okay depending on the wishes of your users, it just makes your chart less flexible than it could be.

Best regards,

DataNibbler

[Anonymous]

Hi Tejaswini,

Use calculated dimension, like:

=if(district id=id's you need,District)

[maxgro · Accepted solution]

if you only want a b

dimension          =if( match(District, 'a','b'), District)

Check "suppress when value is null" flag in dimension tab