Map number values to strings

Q&A
, ,
1

I have a table where I added “group by” date, and then I added rows, average value, one decimal.
I would like to replace the number with mapped string, something like:
1: bad
2: average
3: good

I tried adding a calculated field, but then it only shows “count” in the table.

It’s not letting me do any kind of conditional formatting on a number (except colour and some emojis)

Subject 31/12/2024 31/12/2023
maths 2 3
pe 1 3
art 3 2

My data structure is like this:

|id | name | date | maths | pe | art|
|1 | Sally | 31/12/2024 | 2 | 3| 1|
|2 | Ben | 31/12/2024 | 2 | 3| 1|
|3 | David | 31/12/2024 | 2 | 3| 1|
|4 | Sally | 31/12/2023 | 2 | 3| 1|
|5 | Ben | 31/12/2023 | 2 | 3| 1|
|6 | David | 31/12/2023 | 2 | 3| 1|

2

Hi @Al22,
I would suggest building a calculated field utilizing the switch function:

Let me know if this works for your case or if you have any additional questions.

3

It wasn’t really my case, because I would need to first calculate the average and then apply the switch statement, but that doesn’t let me do any kind of filtering.

It would be nice if there was a feature to conditionally format the numbers into words.

4

@Al22, Understood; yes you could throw something together in a calculated field that does the averaging and then utilizes an ifelse statement to assign a word based on the percentage but that would be a lot of extended work compared to an addition to the conditional formatting.

This has been marked as a feature request to promote visibility to the support team.

Thank you