Convert Likert scale to numbers for calculations (e.g. "very high" = 5)

[Bibaboy10]

Hi all,

My app has some 5-point Likert-scale enum type lists (where users can select "very low" to "very high").

For calculations in my dashboard, I would like to create a virtual column that converts text values to numbers: "very low" = 1, "low" = 2, etc. 

The values are not in a separate referenced table.

Can't seem to figure it out. 

Any help?

Thanks in advance!

[takuya_miyai · Accepted solution]

Hi @Bibaboy10 

It's like this.

Switch([Likert-scale],
"Very high", 5,
"high", 4,
"Normal", 3,
"low", 2,
"Very low", 1,
0
)

[takuya_miyai]

A little something extra.😎
We can also use this text notation.

 

[Bibaboy10]

Thanks!