I don't know this for sure, but my guess is that Tableau is unable to handle the sql_variant data type. Is there a specific reason you're using this data type? Could you try a different data type?
Unfortunately this Table is a part of an "out of box" database we use and can't change the field settings. This field is actually a user input field that stores values of custom fields we define. These Values are what we need to measure metrics on, but as you can see it's not coming through.
1 of 1 people found this helpful
Stephen, please take a look at the following: Support for SQL_Variant data type
The solution to this is to use custom SQL and cast the sql_variant to another data type. Your custom query would look something like this:
CAST(Value as <target data type>) as Value,
This worked Perfect!!!!! Thank you!