Forum Discussion

p1ngu1n's avatar
p1ngu1n
Frequent Visitor
6 years ago
Solved

Line graph or comparable with string values

Hi all,

I have a column where the data is stored as string, lets assume "LOW", "MIDDLE" and "HIGH".

What I want to do is to visualize this in a kind of state diagram, I thought of a line chart with stepped lines.

 

1.) Is there any possiblity to visualize this data without transforming it to integer, such as 1, 2 and 3 for the three values?

2.) If it is required to transform the data, how can I use "LOW", "MIDDLE" and "HIGH" on the y axis to make clear what the values stand for?

 

BR and thanks!

  • dax Thank you for you idea.

    The way I worked around now is to create a column with integer values and use the column with text values as legend. Might be too complicated but works for me 🙂

2 Replies

  • dax's avatar
    dax
    Community Support

    Hi p1ngu1n , 

    I think you need to use number instead of text type in y axis. In addition, if you want to show high, middle, low , you could try to use analytics->trend line in chart to show it. You could refer to my sample for details.

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    • p1ngu1n's avatar
      p1ngu1n
      Frequent Visitor

      dax Thank you for you idea.

      The way I worked around now is to create a column with integer values and use the column with text values as legend. Might be too complicated but works for me 🙂