I'm using tableau with Oracle SQL.
I've tried to use date as a parameter but there's a problem.
Originally, the type of date is string( ex. '20180727'). But when I put the date as parameter, SQL queried the date as a unicode string type like N'20180727'.
(<1.parameter> in Tableau ---> select 20180727 ------> Query in SQL is N'20180727')
If the type of date changes, it takes much more time for query since I'm using index with string type data.
So I really hope to find the way that using parameter with no change of data type.
(<1.parameter> in Tableau ---> select 20180727 ------> Query in SQL is '20180727')
Thanks for reading.
Did you ever get and answer?
hard to envision without seeing your twbx workbook-
I would like to see how the data are cast in tableau and how the parameter is set up
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...