2 Replies Latest reply on Dec 6, 2016 6:29 AM by Chris Dickson

    Syntax for "where clause" to Tableau calculated field\ Measure

    Mahlatse Matabane


      I am struggling with Tableau "where clause". I need to calculate the average speed that is equal to zone plus 10 and group it by ID


      My query looks like this:


      AVG(IF [Speed] >[Zone] and [Speed] <([Zone]+10) then [Speed] end)


      Please assist with a correct syntax for this query.