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

      Hi,

      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.