Grouping numbers into Ranges with a Corresponding Label

Hi guys, noob here. I’m trying to create and display a label which summarizes a numeric value for each item in a table. The numeric column is a rating on a scale of 1-100 and the label will represent a range of values such as 95 to 100, 80 to 94, 70 to 79, etc.

In Excel I would build groups in a pivot table or use a VLOOKUP on the source table, but I can’t figure out how to do the equivalent in AppSheet.

My app is a little personal project that let’s me review video games. I have only a single table (GAMES) with a column called “SCORE”. I added a virtual column called “Score Range” to hold the new label and used a Switch expression thus:

SWITCH(
  [SCORE] >= 95, "Classic",
  [SCORE] >= 86, "Amazing",
  [SCORE] >= 80, "Very Good",
  [SCORE] >= 70, "Good",
  [SCORE] >= 60, "Your mileage may vary",
  [SCORE] >= 50, "Not Bad, but Flawed",
  [SCORE] >= 40, "Bad",
  [SCORE] >= 25, "Horrible",
  [SCORE] < 25, "You've been warned",
  ISBLANK([SCORE]), "none"
)

However, the output of the Switch is a Yes/No value rather than the Text label that I want. I tried IFS and got the same result. Any idea what I can use to get the text I’m after?

Thanks in advance

This should work fine:

IFS(
  [SCORE] >= 95, "Classic",
  [SCORE] >= 86, "Amazing",
  [SCORE] >= 80, "Very Good",
  [SCORE] >= 70, "Good",
  [SCORE] >= 60, "Your mileage may vary",
  [SCORE] >= 50, "Not Bad, but Flawed",
  [SCORE] >= 40, "Bad",
  [SCORE] >= 25, "Horrible",
  [SCORE] < 25, "You've been warned",
  ISBLANK([SCORE]), "none"
)
1 Like

Thank you for the response. I tried exactly that but I still get a Yes/No return rather than Text.
In case it matters, the SCORE column is calculated using an App Formula

Please post a screenshot.

Here’s a cropped selection to show the Test results of the expression along with the actual (on the far right).

What does it look like in the app itself?

It shows as a “N” value for each row that isn’t in the first category (SCORE >= 95). For those rows the value shows as “Y”
image

Please post a screenshot of the entire configuration for the Score Range column, and a screenshot of the column list (from Data >> Columns in the app editor) for the SNES table.

Certainly! Here’s the column configuration. There’s nothing fancy other than the formula

And here are all the columns

Ah I found the problem. It was because I was setting the initial value of the [Gameplay score] column using a Predict model. That column is used in the formula of the SCORE column. I removed that Prediction and the Score Range works!

1 Like

Good catch!

1 Like

Thank you very much for your time

1 Like