ExecuteSQL with an "all" parameter

Discussion created by techtronix on May 21, 2018
Latest reply on May 21, 2018 by philmodjunk

I have a execute SQL statement for a chart and I want a parameter with an "All" option from a drop down list (basically ignoring a "?" parameter. For example, show last year, 2 years ago, 3 years ago, and All Years. Is it possible to do "ALl Years" within a single ExecuteSQL?