7 Replies Latest reply: Nov 30, 2015 9:47 AM by Stefan Wühl RSS

    Can you only have numbers returned in a KPI object?

      I'm trying to return the Mode for the most frequent visitor, and can get that returned via the I.D column in my data using the Mode function to give me the correct number (thats how the IDs are represented, e.g 1, 2, 3, 4 etc), but when trying to set this as a concatenation to show the name instead as I have done in some of my charts using:

       

      "IF ([Visitor ID] = [Visitor ID], [First Name] & ' ' & [Surname], null())"

       

      as part of the function, I simply get a dash.

       

      Is it possible to show text in this way as part of the kpi or must it be a numerical value?