You can create a calculated field similar to the following:
[Measure]<=200 and [Measure]>=100
Then, place this on the filter shelf. A similar calculation can be created using OR in place of AND.
Hope this helps!
Thanks! I knew it was something simple... !
hmmm actually this isn't working.. ?
Below I have the data filtered to show outliers. The formula for "Outlier Filter" is:
and MPGVar is a calculated field:
Looking at the variance of the previous 52 MPG records. If it's more than .5 MPG I want it on the report.
Below the filter is set to TRUE.
It looks OK on the surface but when I turn OFF the filter, for those same records you see a lot more data:
What I'm wanting is to see ALL of the records for a particular vehicle if that vehicle had more than .5 MPG variance at any time. What I'm seeing is only the records where the MPG variance is .5.
Obviously I could add this to the data source before I extract it but I'm trying to avoid that. I'd rather know how to properly do it inside Tableau.