Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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??
if you only want a b
dimension =if( match(District, 'a','b'), District)
Check "suppress when value is null" flag in dimension tab
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
Hi Tejaswini,
Use calculated dimension, like:
=if(district id=id's you need,District)
if you only want a b
dimension =if( match(District, 'a','b'), District)
Check "suppress when value is null" flag in dimension tab