Challenge: Analyzing Profit Changes Between 2016 and 2017
Your task is to create a bullet graph to compare the Profit from 2016 and 2017 across different categories.
- Drag the "Sub-Category" field to the Rows Shelf.
- Drag the "2017s Profit" field (created in the previous chapter) to the Columns Shelf.
- Drag the "2016s Profit" field to the Marks area and place it under "Detail".
- Add a Reference Line:
- Set the Value to "2016s Profit";
- Set the Aggregation to "Total, Per Cell".
- Customize the Reference Line by adjusting the color and transparency to make it more visible.
- Review the chart to identify categories with negative "2017s Profit" but positive "2016s Profit".
Everything was clear?
Thanks for your feedback!
SectionΒ 4. ChapterΒ 2
Ask AI
Ask AI
Ask anything or try one of the suggested questions to begin our chat
Suggested prompts:
Can you explain how to interpret the bullet graph once it's created?
What should I look for when comparing 2016 and 2017 profits in the chart?
Can you help me identify which sub-categories have negative 2017 profit but positive 2016 profit?
Awesome!
Completion rate improved to 2.63Challenge: Analyzing Profit Changes Between 2016 and 2017
Swipe to show menu
Your task is to create a bullet graph to compare the Profit from 2016 and 2017 across different categories.
- Drag the "Sub-Category" field to the Rows Shelf.
- Drag the "2017s Profit" field (created in the previous chapter) to the Columns Shelf.
- Drag the "2016s Profit" field to the Marks area and place it under "Detail".
- Add a Reference Line:
- Set the Value to "2016s Profit";
- Set the Aggregation to "Total, Per Cell".
- Customize the Reference Line by adjusting the color and transparency to make it more visible.
- Review the chart to identify categories with negative "2017s Profit" but positive "2016s Profit".
Everything was clear?
Thanks for your feedback!
SectionΒ 4. ChapterΒ 2
