## Task

Your task is to compare **Sales** and **Profit** from **California** and **New York** against all other states. Follow these steps:

1. Create a calculated field named **"My States"** with the following formula:  
```sql  
IF [State] = 'California' OR [State] = 'New York' THEN 'CA and NY'  
ELSE 'Other States'  
END  
```  
2. Drag the **"My States"** field to the **Rows Shelf**.  
3. Drag the **"Sales"** and **"Profit"** fields to the **Columns Shelf** to create two charts on a single canvas.  

This corse provides a comprehensive introduction to Tableau's core features, empowering learners to create impactful data visualizations and dashboards. We will cover essential topics such as working with charts, filters, calculated fields, and parameters, as well as advanced techniques like combining data and creating interactive dashboards. By the end, you will have the skills to transform raw data into actionable insights with ease and confidence.

This section lays the groundwork for mastering Tableau by guiding you through installation, navigation, and foundational operations. From performing joins and splitting columns to understanding filters, marks, and the data pane, you will be equipped with essential tools for data exploration and visualization. 

This section delves into Tableau's powerful tools for data organization, filtering, and customization. You'll learn to differentiate dimensions and measures, work with continuous and discrete fields, and create calculated fields and interactive dashboards. Through practical challenges, you'll apply these tools to analyze data, uncover insights, and enhance your visualizations.

This section focuses on creating impactful visualizations to uncover patterns and trends in your data. From heatmaps and scatter plots to treemaps and combination charts, you'll explore a variety of chart types tailored to different analytical needs.

This section introduces advanced visualization techniques to enhance data analysis and storytelling. You'll learn to create bullet graphs, stacked area charts, histograms, and box plots, enabling deeper insights into trends, distributions, and comparisons.

Challenge: Comparing California and New York to Other States

Task

Challenge: Comparing California and New York to Other States

Task