Visualizing non-numeric data

[Former Member]

I am wanting to visualize the answer to a yes/no question. I was thinking a bar chart would be ideal, but I imagine the bars would need to be the same size, but maybe color code them. Yes = green, No = red.

In this example, I might have 10 stores, and let's say it's a question like, "Offers delivery service?".

Store 1 = No

Store 2 = No

Store 3 = Yes

....

Any thoughts on a direction for me?

Lumira 1.28

Justin

[varunanand · Accepted solution]

Hi Justin,

There are couple of options,

- convert the Yes/No column to a measure and use it in a column/bar chart.

- replace Yes with 1 and No with 0 and use this measure in column/bar chart.

- leverage conditional formatting to indicate the two colors.

Please let me know if there are nay questions or comments.

Thank you,

Varun Anand

[TammyPowlas]

Can you set up your data where yes is a column, no is a column and then add counts? See below

[Former Member]

I thought about doing something similar, my desire was an easier method as I have potentially dozens of columns to contend with. I may try this suggestions and see if it's doable for me. I guess I was really wondering if Lumira could magically deal with text values without the conversion.

Thanks again for the quick reply, I'll mess around some more and get back with the thread.