使用 Tableau 创建热图

我是 Tableau 新手（第一天）。 我有下面的数据D*指的是彼此相关的三个变量之一。每个有 3 个实例D*多变的。当相同的变量相互对立时，我放置了一个NA.

我想根据这些数据制作热图，其中相关值（系数）转换为颜色。我该如何重新格式化数据或以其他方式实现此目的？

如果我的问题表述得不够清楚，请在评论中告诉我。

    D1  D1  D1  D2  D2  D2  D3  D3  D3
D1          
D1  
D1  
D2  0.3 0.3 0.3 
D2  0.4 0.2 -0.2    
D2  0.1 0.3 0.4     
D3  0.6 0.6 0.6 0.2 0.2 0.2 
D3  0.6 0.8 0.9 0.4 0.2 -0.2    
D3  0.7 0.7 0.7 0   0.2 0.2 

步骤 1：使用与上面提供的表格完全相同的表创建 Excel 电子表格，但通过根据需要添加 a、b 和 c 来重命名不同的 D* 实例。保存 Excel 电子表格。

Step 2: Open Tableau and connect to the Excel file

Step 3: Select columns D1a to D3c

Step 4: Hover your mouse and click on the drop down arrow and select pivot

Step 5: Double click on F1, Pivot field names and Pivot field values and rename as appropriate. Note the slight variations in the names.

Step 6: Change the data type for correlation coefficients. Click on Abc and change as shown. Click on Sheet 1 when you are done.

Step 7: Right click on Correlation Coefficients and click Convert to measure.

Step 8: Drag the different D* fields to the row and column shelves exactly as shown. Drag Correlation Coefficients onto the Color Marks card.

Step 9: Click on “Abc” at the top as shown. Hover your mouse and click on the drop down arrow and Edit colors.

Step 10: Choose the options shown below. Feel free to use this format if you wish.

Step 11: Click on the end member green color and select the lighter green color as shown. Deselect “Use Full Color Range”. Click OK.

Step 12: Format the Correlation Coefficients as shown.

Step 13: You just built your first Tableau visualization! Well done.