Pie Category Definition string concatenating with integer

hatra
edited February 11, 2022 in Analytics #1

Hi,
I have requirement that I have to concatenating a column with "countries" name ( string ) and a column "percentage of Total risk" ( integer ) , I have noticed that it is not possible to create a computed column concatenating String with Integer.
any work around ?
thanks in advance

Comments

  • jfranken
    edited June 7, 2019 #2

    You can concatenate a string and an integer. The chart category expression should be:

    row["countries"] + row["percentage of Total risk"]

    Include the quotes around the column names. The column names are case sensitive.

    Alternatively, you can add a computed column in the data set with the same expression and select the computed column in the chart. If you are still having issues concatenating the columns, please provide more details or post an example.

    Warning No formatter is installed for the format ipb