Create a heat map to display the order
Publish By:
Admin,
Last Updated:
16-Oct-23
Price:
$120
-
Objective: Create a Heat Map to display the Order Date Quarter for each Category. 1. New worksheet. Rename it Heat Map.
2. Drag Order Date to the Columns shelf. 3. Expand to show Quarter. 4. Right-click the Year pill and select Remove.
5. Drag Category to the Rows shelf. 6. Drag Profit to Color. 7. Drag Sales to Size.
8. Right-click the Quarter pill and select the Quarter from the second tier to show the Quarter and Year. This will convert the dimension to a measure.
9. Change the Marks Type to Square. 10.Click Size and advance the slider to increase the size of the marks.