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).
You may have to use LODs for this example, most likely exclude.
Have you got a sample workbook that you can provide us?