1 Reply Latest reply on Dec 7, 2018 2:41 PM by Mavis Liu

    Using WHERE clause in Tableau

    Heather Disney

      I am trying to recreate the below SQL statement in Tableau, but since Tableau does not use WHERE clauses, I'm unsure of how to do it.  Could someone please point me in the right direction?

       

      What I'm trying to create in Tableau:

       

      IF [Number of Efforts Started in 2019] > 1 And [Start Quarter]='Q1 2019'

      THEN [Risk Remediated]= ([Risk Remediated] + (10* [Number of Efforts Started in 2019])) WHERE Quarter='Q1 2020'  END

       

      Note:  Number of Efforts Started in 2019 is a parameter (will take any integer).

      Start Quarter is a parameter (list).

       

      Thank you!