Tableau Challenges #4 Link Tableau Challenges Solutions #4 Link
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
There is no 5th challenge in this summary. If someone wants to add their own version, then write to me in telegram @Ekaterina_Kalabush or by email [email protected] . I will give you the rights to edit the document.
Create a so-called waterfall graph that shows the cumulative effect along a chain of consecutive values.
Step 1: create a chart Order Date in Columns, Profit in Columns, Region add to filters.
Step 2: Add Quick Table Calculations → Running Total for Profit.
Step 3: Change the chart type to Gantt Bar, add Profit to Color
Step 4: Create a Calculated Field Negative Profit and drag it to Size
-[Profit]
Done! We have created a waterfall graph that shows the cumulative effect along a chain of consecutive values. Also, the step-by-step process of constructing this type of graphs can be explored in this video https://www.youtube.com/watch?v=q_4Y0-6xsUk
Create a table with sparklines and a bar chart at the end.
Step 1: Create the 1st and 2nd chart. Drag to Columns Order Date (Month), to Browse - Category, the field with Fixed (I'll write below), Sales, and Sales to Text. Add Category to the filters. Also apply the filter to the second sheet with bars, which we will create in step 2. The filter helps prevent the dashboard from breaking.
{ FIXED [Category]: sum([Sales])}