Tableau Challenges #6 Link Tableau Challenges Solutions #6 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
****Create a sales table for each subcategory and segment. Configure the visualization so that when you hover over the table value, the corresponding row and column are highlighted.
Step 1: Create a Parameter Category or Sub-Category? and the second Parameter Segment or Region? to allow the end user to select the dimensions of the table vertically by category or subcategory, horizontally by segment or region
Step 2: Using the parameters fron step 2 create calculated fields: Category/Sub-Category и Segment/Region
IF [Category or Sub-Category?] = 'Category' THEN [Category] ELSEIF [Category or Sub-Category?] = 'Sub-Category' THEN [Sub-Category] END
IF [Segment or Region?] = 'Segment' THEN [Segment] ELSEIF [Segment or Region?] = 'Region' THEN [Region] END
Step 3: Create table. Drag the Segment/Region pill to Columns, the Category/Sub-Category pill to Rows, the Sales (SUM) pill to Text.
Step 4: Double-clicking on the row where Columns, enter MIN(1), thereby we create an additional axis
Step 5: Click on the axis of MIN(1), then click Edit Axis. Select Range Fixed from 0 to 1. Thus, the blue stripes become continuous. Uncheck the Show Header, since we don't need the MIN(1) axis on visualization.