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".
Все було зрозуміло?
Дякуємо за ваш відгук!
Секція 4. Розділ 2
Запитати АІ
Запитати АІ
Запитайте про що завгодно або спробуйте одне із запропонованих запитань, щоб почати наш чат
Awesome!
Completion rate improved to 2.63
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".
Все було зрозуміло?
Дякуємо за ваш відгук!
Секція 4. Розділ 2