1 Reply Latest reply on Jan 3, 2014 2:44 PM by Mauricio Palomar

    Cast Metric as String

    Mauricio Palomar

      Greetings!

      I am following this tutorial as a reference point:

      http://steineranalytics.com/2013/10/07/how-to-create-tableau-sparkline-chart-with-min-max-highlights-and-label-values/

       

      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?