Is it possible have a parameter which contains the whole WHERE clause?
SELECT [Customer], [State] FROM [dbo].[Customers]
So the <Parameters.MyParameter> could be populated as necessary...
'WHERE [State] like 'Man%'
'WHERE [State] like 'Man%' and [Customer] = 'IBM'
'WHERE [State] = 'Cheshire' and [Customer] LIKE 'HP%'
I have this working fine with
WHERE [State] like '<Parameters.MyParameter>%'
I am finding this too restrictive and need to pass the whole WHERE clause.
Any advise would be much appreciated.
Tableau Version 10.2.0
I'm not sure this would be what you looking for but what about something like :
WHERE [State] LIKE 'Man%'
OR [State] = 'Cheshire'
AND [Customer] = 'IBM'
OR [Customer] LIKE 'HP%'
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...