Filtering with a groups dimension

[#1]

Hi,

I haven't been able to find any answers to this question, so I'm hoping I'm not repeating an existing discussion, but here goes!

I have a chart that displays a grouped dimension (city, state, country) and a metric.  There is an unknown value in each one of these dimensions, but that unknown value is different for each one - Unknown City and Unknown State.  I'd like to filter out the unknowns when the group dimension is cycled to city or state because it's the dimension with the largest number of rows, and skews the look of the graph.  However, I don't want that filtering to affect the other dimensions.

Essentially, what I'm looking for is conditional filtering of the dimension, based on the group dimension I'm currently showing.  Any advice?  Thanks!

George

[nagaiank · Accepted solution]

You may define unknown values as nulls. Then if you plot the chart with 'Suppress When Value is Null' in the Dimensions tab of chart properties checked, you will get the desired result. The attached example illustrates this.