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.
Oliko kaikki selvää?
Kiitos palautteestasi!
Osio 2. Luku 9
Kysy tekoälyä
Kysy tekoälyä
Kysy mitä tahansa tai kokeile jotakin ehdotetuista kysymyksistä aloittaaksesi keskustelumme