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.
¿Todo estuvo claro?
¡Gracias por tus comentarios!
Sección 2. Capítulo 9
Pregunte a AI
Pregunte a AI
Pregunte lo que quiera o pruebe una de las preguntas sugeridas para comenzar nuestra charla
Awesome!
Completion rate improved to 2.63
Challenge: Comparing California and New York to Other States
Desliza para mostrar el menú
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.
¿Todo estuvo claro?
¡Gracias por tus comentarios!
Sección 2. Capítulo 9