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.
Everything was clear?
Thanks for your feedback!
SectionΒ 2. ChapterΒ 9
Ask AI
Ask AI
Ask anything or try one of the suggested questions to begin our chat
Awesome!
Completion rate improved to 2.63
Challenge: Comparing California and New York to Other States
Swipe to show 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.
Everything was clear?
Thanks for your feedback!
SectionΒ 2. ChapterΒ 9