Challenge: Comparing California and New York to Other States
Task
Your task is to compare Sales and Profit from California and New York against all other states. Follow these steps:
- Create a calculated field named "My States" with the following formula:
IF [State] = 'California' OR [State] = 'New York' THEN 'CA and NY'
ELSE 'Other States'
END
- Drag the "My States" field to the Rows Shelf.
- Drag the "Sales" and "Profit" fields to the Columns Shelf to create two charts on a single canvas.
Var alt klart?
Tak for dine kommentarer!
Sektion 2. Kapitel 9
Spørg AI
Spørg AI
Spørg om hvad som helst eller prøv et af de foreslåede spørgsmål for at starte vores chat
Awesome!
Completion rate improved to 2.63
Challenge: Comparing California and New York to Other States
Stryg for at vise menuen
Task
Your task is to compare Sales and Profit from California and New York against all other states. Follow these steps:
- Create a calculated field named "My States" with the following formula:
IF [State] = 'California' OR [State] = 'New York' THEN 'CA and NY'
ELSE 'Other States'
END
- Drag the "My States" field to the Rows Shelf.
- Drag the "Sales" and "Profit" fields to the Columns Shelf to create two charts on a single canvas.
Var alt klart?
Tak for dine kommentarer!
Sektion 2. Kapitel 9