Show Me panel for recommendations in Tableau - Cell-by-Cell Formula Trace

Sample Data

Sample sales data by region with sales and profit values.

Cell	Value
A1	Region
B1	Sales
C1	Profit
A2	East
B2	1000
C2	200
A3	West
B3	1500
C3	300
A4	North
B4	1200
C4	250
A5	South
B5	1300
C5	270

Formula Trace

Show Me panel recommendation based on selected fields: Region, Sales, Profit

Step 1: User selects 'Region' (dimension) and 'Sales' (measure)

Step 2: User adds 'Profit' (second measure) to selection

Step 3: User selects only 'Sales' and 'Profit' (two measures, no dimension)

Step 4: User selects 'Region' only (one dimension)

Cell Reference Map

    A       B       C  
1 |Region | Sales | Profit|
2 | East  | 1000  |  200  |
3 | West  | 1500  |  300  |
4 | North | 1200  |  250  |
5 | South | 1300  |  270  |

The data fields Region, Sales, and Profit are used as inputs for Show Me recommendations.

Result

Show Me Panel Recommendations:

Selection: Region + Sales
-> Recommended: Bar Chart, Map

Selection: Region + Sales + Profit
-> Recommended: Scatter Plot, Dual-Axis Chart

Selection: Sales + Profit
-> Recommended: Scatter Plot, Histogram

Selection: Region
-> Recommended: Text Table, Highlight Table

Shows how Tableau's Show Me panel suggests chart types based on the fields selected.

Sheet Trace Quiz - 3 Questions

What chart does Show Me recommend when you select one dimension and one measure?

A Scatter plot

B Bar chart or map

C Histogram

D Text table

Key Result

Show Me panel recommends chart types based on the count and type of selected fields: dimensions and measures.