Y series value in chart

hatra
edited February 11, 2022 in Analytics #1

Hi all,
I have a chart that has a Y series which returns 1 and 2 ( values on radar chart )
I would like to change the value to show 1 to "yes" and 2 for "no",
thanks

Comments

  • jfranken
    edited December 21, 2019 #2

    Change the data expression to something like:

    if (row["myNumericValueColumn"] == 1) {
    "yes"
    } else {
    "no"
    }

    You can do this inside the chart editor, or you can create a data set computed column and use that column for the chart data. If you don't see the computed column in the chart editor, manually refresh the chart's data binding.

    Warning No formatter is installed for the format ipb