2 Replies Latest reply on Jun 27, 2016 9:56 AM by Dmitry Chirkov

    Custom SQL Parameter

    chakradhar kakani

      Hello Tableau Users.

       

      I'm trying to figure a SQL for custom Parameter. I want to filter the data at source level using parameter in Custom SQL Query. I want to filter the data of a column called Profit . So I want to insert a Custom Parameter at SQL level to filter the data at the source level.

       

      My requirement is filter the data on the dashboard for a condition Profit >1 and Profit < 1000. the user in type in what ever number he likes between 1 to 1000 to filter the data means to show the whole dashboard who profit is greater then 1 or less than 1000. is there any workaround for this by writing custom SQL query or any other work around without writing the SQL for custom parameter.

       

      Appreciate the help.

       

      Thanks