Device-specific layouts in Tableau - Cell-by-Cell Formula Trace

Sample Data

Sales data by device type for a company

Cell	Value
A1	Device
B1	Sales
A2	Desktop
B2	1000
A3	Tablet
B3	600
A4	Phone
B4	400

Formula Trace

IF [Device] = 'Phone' THEN 'Phone Layout' ELSEIF [Device] = 'Tablet' THEN 'Tablet Layout' ELSE 'Desktop Layout' END

Step 1: [Device] = 'Phone' for each row

Step 2: IF condition for Phone is True, assign 'Phone Layout' else check next

Step 3: [Device] = 'Tablet' for remaining rows

Step 4: Assign 'Tablet Layout' if True else 'Desktop Layout'

Cell Reference Map

   A       B
1 Device  Sales
2 Desktop 1000
3 Tablet  600
4 Phone   400

References: [Device] column used in IF conditions

The formula uses the Device column values from A2 to A4 to decide layout

Result

   A       B      C
1 Device  Sales  Layout
2 Desktop 1000   Desktop Layout
3 Tablet  600    Tablet Layout
4 Phone   400    Phone Layout

The new Layout column shows which device-specific layout applies to each device type

Sheet Trace Quiz - 3 Questions

What layout is assigned to the Tablet device?

A Phone Layout

B Tablet Layout

C Desktop Layout

D No Layout

Key Result

IF device equals 'Phone' THEN 'Phone Layout' ELSEIF device equals 'Tablet' THEN 'Tablet Layout' ELSE 'Desktop Layout'

Practice

1. What is the main purpose of device-specific layouts in Tableau dashboards?

easy

A. To create different dashboard designs optimized for phones, tablets, and desktops

B. To connect Tableau to different data sources automatically

C. To change the color scheme of a dashboard based on user preferences

D. To export dashboards in multiple file formats

Solution

1. Step 1: Understand device-specific layouts

   Device-specific layouts allow creating different dashboard versions tailored for various devices like phones, tablets, and desktops.

2. Step 2: Identify the main purpose

   The main goal is to improve user experience by optimizing the dashboard layout for each device type.

3. Final Answer:

   To create different dashboard designs optimized for phones, tablets, and desktops -> Option A

4. Quick Check:

   Device-specific layouts = tailored dashboard designs [OK]

Hint: Think about device screen sizes and user experience [OK]

Common Mistakes:

• Confusing device layouts with data connections
• Thinking device layouts change colors only
• Assuming device layouts export files

2. Which Tableau feature allows you to preview how your dashboard looks on different devices?

easy

A. Calculated Fields

B. Data Interpreter

C. Story Points

D. Device Preview

Solution

1. Step 1: Recall Tableau features for device layouts

   Tableau provides a feature called Device Preview to check dashboard appearance on phones, tablets, and desktops.

2. Step 2: Match feature to description

   Device Preview specifically lets you test and adjust layouts for different devices before publishing.

3. Final Answer:

   Device Preview -> Option D

4. Quick Check:

   Preview device layouts = Device Preview [OK]

Hint: Look for 'Preview' in the feature name for device testing [OK]

Common Mistakes:

• Confusing Device Preview with Data Interpreter
• Mixing up Story Points with device layout tools
• Thinking Calculated Fields preview layouts

3. Given a dashboard with device layouts set for phone and desktop, what happens if a user opens it on a tablet without a specific layout?

medium

A. The desktop layout is shown by default

B. The phone layout is shown by default

C. An error message appears

D. The dashboard does not load

Solution

1. Step 1: Understand default layout behavior

   If a device-specific layout is not created for a device (tablet here), Tableau uses the desktop layout as the default fallback.

2. Step 2: Apply to the scenario

   Since only phone and desktop layouts exist, tablet users see the desktop layout automatically.

3. Final Answer:

   The desktop layout is shown by default -> Option A

4. Quick Check:

   Missing tablet layout = desktop layout fallback [OK]

Hint: No tablet layout? Desktop layout shows [OK]

Common Mistakes:

• Assuming phone layout shows by default
• Expecting error messages for missing layouts
• Thinking dashboard fails to load

4. You created device-specific layouts but notice the phone layout is not applied when viewing on a phone. What is a likely cause?

medium

A. The desktop layout has higher priority and overrides phone layout

B. Tableau does not support phone layouts

C. The phone layout was not enabled in the Device Layouts pane

D. The data source is incompatible with phone layouts

Solution

1. Step 1: Check device layout settings

   Device-specific layouts must be enabled explicitly in Tableau's Device Layouts pane for each device type.

2. Step 2: Identify common mistake

   If the phone layout is created but not enabled, Tableau will not apply it when viewed on a phone.

3. Final Answer:

   The phone layout was not enabled in the Device Layouts pane -> Option C

4. Quick Check:

   Enable phone layout to apply it [OK]

Hint: Enable layouts in Device Layouts pane to activate [OK]

Common Mistakes:

• Thinking desktop layout overrides phone layout
• Believing Tableau lacks phone layout support
• Blaming data source for layout issues

5. You want to create a dashboard that shows a detailed sales chart on desktop but a simplified summary on phones. How should you use device-specific layouts to achieve this?

hard

A. Use one layout and rely on Tableau to automatically simplify visuals on phones

B. Create separate layouts: full chart for desktop, summary for phone, and enable both

C. Create only a phone layout with the summary and no desktop layout

D. Create a desktop layout with summary and phone layout with full chart

Solution

1. Step 1: Plan layouts for each device

   To show different visuals per device, create separate layouts tailored to each device's needs.

2. Step 2: Implement and enable layouts

   Create a detailed sales chart layout for desktop and a simplified summary layout for phones, then enable both in Device Layouts.

3. Step 3: Verify user experience

   This ensures desktop users see full details, and phone users get a clean summary optimized for small screens.

4. Final Answer:

   Create separate layouts: full chart for desktop, summary for phone, and enable both -> Option B

5. Quick Check:

   Separate layouts for devices = tailored user experience [OK]

Hint: Design and enable distinct layouts per device type [OK]

Common Mistakes:

• Expecting automatic simplification without separate layouts
• Creating only one layout for all devices
• Mixing up which layout shows on which device