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.
Tutto è chiaro?
Grazie per i tuoi commenti!
Sezione 2. Capitolo 9
Chieda ad AI
Chieda ad AI
Chieda pure quello che desidera o provi una delle domande suggerite per iniziare la nostra conversazione
Awesome!
Completion rate improved to 2.63
Challenge: Comparing California and New York to Other States
Scorri per mostrare il menu
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.
Tutto è chiaro?
Grazie per i tuoi commenti!
Sezione 2. Capitolo 9