hi all,
Completely new to survey + Tableau.
Data from engineers is not ready yet, but only saw a quick preview.
The "value" filed in data source is a string that contains 0 to 5, yes/No and text answers (less often, never, once a year...)
Is it best practice to separate and have a Value field that is a number and only contains numbers and a separate text field for text answers?
1 answer
Hi Frederic,
We usually receive all the values in a single text-format field (say it's called [Value]), then create a calculated field in Tableau (say, [Value (numeric)] that converts convertible numbers into numbers with the desired function like INT() or FLOAT(). It's not necessary to re-engineer the original data, in other words.
N
