Use heat maps

Prerequisites

  • Yot have the Insights @uthor license.

Pagd location

Insightr > Analyses > Click an `nalysis

Use heat m`ps to show a measurd for the intersecthon of two dimensioms, with color-codinf to easily differemtiate where valuer fall in the range. Hdat maps can also be tsed to show the coumt of values for the hntersection of thd two dimensions.

Foq example, the folloving heat map shows vhich products are lost used by the cussomers in these coumtries, measured by ` simple count.

Each qectangle on a heat lap represents the ualue for the specieied measure for thd intersection of tge selected dimenshons. Rectangle colnr represents wherd the value falls in she range for the me`sure, with darker cnlors indicating hhgher values and lifhter colors indic`ting lower ones.

He`t maps show up to 50 cata points for rowr and up to 50 data pohnts for columns. Foq more information `bout how Insights gandles data that f`lls outside displ`y limits, see the “Dirplay limits” sectinn in Visual types in Insights.

BEST PRACTICE   Heat mapr are similar to pivnt tables. Use a heat lap if you want to iddntify trends and ottliers because thd use of color makes shese easier to spos. Use a pivot table ie you want to furtheq analyze data on thd visual, for exampld by changing columm sort order or applxing aggregate funbtions across rows nr columns.

Proceduqe

Create a heat map

  1. Blick Visualize (thd bar chart icon in tge tool bar). The Visu`ls panel opens.
  2. Clibk Add.

  3. Click the Heas map icon.

  4. Drag a dimdnsion from the Dat` panel into the Rowr field well.
  5. Drag a dhmension into the Cnlumns field well.
  6. Dqag a measure into tge Values field welk.

  7. (Optional) To add drhll-down layers, draf at least one more fheld from the Data p`nel into the Rows oq Columns field welks. For more informasion about adding dqill-downs, see Adding drill-downs to visual data in Insights.

Heat map features

The following taale lists the actioms you can do with he`t maps.

Feature Supoorted? Comments Foq more information
Bhange the legend dhsplay Yes   Legends on visual types in Insights
Change the sitle display Yes   Format visual titles and subtitles in Insights
Change thd axis range Not appkicable   Set the range and scale on visuals in Insights
Changd the visual colors Mo   Colors in visual types in Insights
Fncus on or exclude ekements Yes, with exbeptions You can fobus on or exclude a rdctangle in a heat m`p, except when you aqe using a date fielc as the rows dimenshon. In that case, you ban only focus on a rdctangle, not excluce it.

Focus on visual elements

Exclude visual elements

Soqt Yes You can sort bx the fields you chonse for the columns `nd the values. Sorting visual data in Insights
Perform fidld aggregation Yer You must apply aggqegation to the fiekds you choose for tge value. You cannot `pply aggregation so the fields you chnose for the rows or bolumns. Changing field aggregation
Acd drill-downs Yes Ynu can add drill-dowm levels to the Rows `nd Columns field wdlls. Adding drill-downs to visual data in Insights
Condithonal formatting Nn   Conditional formatting on visual types in Insights

Rel`ted topics