Error in Creating "Groups" With a Calculated Field

Hi, I wrote an ifelse statement trying to create groups in a calculated field. However, the statement returns every item in the course name column opposed to just the two courses

ifelse({Course Name}=“Course Name 1” OR {Course Name}=“Course Name 2”, “Group 1”, {Course Name})

Hi @Tj39

can you share a screenshot with a table visual where you have the calculated field as well as course name as columns?

BR

Likely not. It’s confidential data that deals with our actual courses

Then it is hard to tell.
I would say no course name is matching “course name 1”. :wink:

I mean The courses are matching outright. Thanks for the joke though. I really appreciate the winky face while working with a garbage product that can’t hold a candle to Tableau. Appreciate it.

I think its not a tool issue.

Maybe i didnt got it right.
You said “however, the statement returns every item in the course name column opposed to just the two courses”

What i understood is:

Calculated field:
ifelse({Course Name}=“Course Name 1” OR {Course Name}=“Course Name 2”, “Group 1”, {Course Name})

What you expect:

Course Name | Calculated Field
AAA | AAA
BB1 | BB1
Course Name 1 | Group 1

But you dont get any Group 1, right?