2 Replies Latest reply on Jan 8, 2019 11:51 AM by Heather Disney

    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!