Assume a table structure
Now i want a dimension/measure that can give me unique values of col1 and col2 combined.
can way i can do it ?
So to combine the fields you can concatenate the columns (this only works on strings, so we need to cast them to strings too)
STR([Col -1])+' '+STR([Col - 2])
we can then take a COUNTD of this new field...or just combine the whole thing into one formula
COUNTD(STR([Col -1])+' '+STR([Col - 2]))
Let me know if that doesn't make sense, or doesn't solve you issue.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...