Tableau Challenges #5 Link Tableau Challenges Solutions #5 Link

Video review on YouTube

Join the Vizuators team!

Website: https://vizuators.by/ Telegram: https://t.me/viz_techreview Tableau Public: https://public.tableau.com/app/profile/vizuators.challenges Youtube: https://www.youtube.com/c/Vizuators Instagram: https://instagram.com/vizuators Facebook: https://www.facebook.com/vizuators.by/ Twitter: https://twitter.com/vizuators LinkedIn: https://www.linkedin.com/company/vizuators

Abstract author: Ekaterina Kalabush

Challenge 1

Add a cumulative distribution plot to the histogram

Step 1: Create a Profit histogram. Drag Profit (bin) to Columns, Profit (CNT) to Rows.

Untitled

Step 2: Mark Type → Line Duplicate Profit (CNT) in Rows, select Quick Table Calculations → Running Total, and also change Mark Type → Line

Untitled

Untitled

Step 3: Click Dual Axis.

Untitled

Step 4: Synchronize Axis and hide header of the second axis unchecking the Show Header.

Untitled

Done! We have plotted the cumulative distribution to the histogram.

Challenge 2

Show how many times customers have purchased each combination of product categories at the same time.

Step 1. I use the Data Source Sample - Superstore. Join the data, as in the photo. Orders 1 is a copy of Orders.

Untitled

Step 2: Drag Sub-Category to Columns, Sub-Category Sub-Category (Orders1) to Rows. Order ID (CNTD) to Color and Text.