Filter dimensions in a chart

[#1]

I have 4 charts that are point at tables that are filtered by yesterday's date.  In one of the bar charts, I want to show the count of any records that have 'Wrong' in the defect field.  I could filter the data, but that would compromise the other charts - I'd like to do in the chart itself.  In another chart, I want to show the top 5 defects excluding one particular defect (always the highest and skews the data).  Any help would be appreciated.

[MayilVahanan]

Hi

Try like this

I want to show the count of any records that have 'Wrong' in the defect field.:

= Count({<defect = {'Wrong'}>} FieldName)

I want to show the top 5 defects excluding one particular defect :

Use dimension limit or rank functions.

[#3]

I think that is getting me closer.  I put that statement in the defintion box of the expressions tab.  How would I write this to look for Wrong anywhere in the defect?  Something similar to  - defect Like '*Wrong*' - in previous work I've done.  I tried playing with the syntax, but could never get it right.

[MayilVahanan · Accepted solution]

HI

Try like this

= Count({<defect = {'*Wrong*'}>} FieldName)

[#5]

Thanks for the help - that did it.

[#6]

One more question on the other chart - how would the expression look for exclduing one defect?  Not like '*Delay*'

[MayilVahanan]

HI

Try like this

= Count({<defect -= {'*Delay*'}>} FieldName)

[#8]

Thanks again - that did it as well.  Was not familiar with the '-=' as not equal, but am now.