I am following this tutorial as a reference point:
The problem I am having is I have a mix of strings, floats, and integers for my metric column. When create this calculated field:
LOOKUP ( SUM([Amount]), FIRST())
... the numeric values shows up fine but the string values defaults to NULL. I would like the string values to show up as literals or their string value.
I've tried using the STR() function but it's not working in this case. Still getting NULLs.
Anything else I can do here?
I figured this out:
I created another column called 'metric_value_string' ... and adjusted the calculated filed as so:
IF (ATTR([Metric]) = 'string_metric_name')
(LOOKUP (ATTR([metric_value_string]), FIRST()))
STR((LOOKUP (SUM([metric_value]), FIRST())))
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...