KNOWLEDGE BASE

Filter Based On First Value to Meet or Exceed Target


Published: 03 Oct 2016
Last Modified Date: 10 Oct 2016

Issue

How to filter on the first value to meet or exceed a target value. 

Environment

  • Tableau Desktop 10.0.1

Resolution

Use the LOOKUP() table calculation. If the current mark is less than the target value, or the current mark is >= target value and the previous mark is not, this calculation returns True:
NOT([!Meet or Exceed Target?])

OR

[!Meet or Exceed Target?] AND NOT(LOOKUP([!Meet or Exceed Target?], -1))
Drag this calculated field to the Filters shelf.
Did this article resolve the issue?