Toucan 3.0
YouPrep documentationHelp centerGet a demo
  • Welcome
    • ๐Ÿ‘‹Welcome to Toucan
    • โš™๏ธTechnical resources
      • โš™๏ธToucan stack
      • Setup mode
        • Toucan SaaS mode
      • โš™๏ธSecurity
        • Application Security
        • Source Code Quality
        • Global Security Practices
        • Security of Docker Images
  • TUTORIALS
    • ๐Ÿ“ŠGetting Started : Embedded Analytics
    • ๐Ÿค“Advanced tutorials
      • Embedding a story with user attributes
        • Dynamic filter with user attributes
        • Dynamic Tables
        • Dynamic Database
        • Dynamic Host
      • Using the HTTP API connector in advanced use cases
      • Using advanced syntax for SQL queries
      • Merging filters with our tool
      • Deep customization chart (CSS)
        • Homepage customization
        • Chart customization
        • Dashboard customization
  • Data Management
    • ๐ŸงฎOverview of Data In Toucan
    • ๐Ÿ“กDatasources in Toucan
      • ๐Ÿ”ŒManaging Connectors
        • ๐Ÿ”ŒCreating, editing and deleting a connector
        • ๐Ÿ”ŒSet up OAuth2 credentials for your platform
        • ๐Ÿ”ŒSetting up a connector
          • ๐Ÿ”ŒGeneric Connectors
            • ๐Ÿ”ŒSetting up an HTTP API connector
            • ๐Ÿ”ŒSetting up an ODBC Connector
          • ๐Ÿ”ŒDatabase and data warehouse Connectors
            • ๐Ÿ”ŒSetting up an AWS Redshift Connector
            • ๐Ÿ”ŒSetting up a Snowflake Connector
            • ๐Ÿ”ŒSetting up a PostgreSQL Connector
            • ๐Ÿ”ŒSetting up a Google Big Query Connector
            • ๐Ÿ”ŒSetting up an AWS Athena connector
            • ๐Ÿ”ŒSetting up a MySQL connector
            • ๐Ÿ”ŒSetting up a MongoDB connector
            • ๐Ÿ”ŒSetting up a Microsoft SQL Server connector
            • ๐Ÿ”ŒSetting up an Azure SQL connector
            • ๐Ÿ”ŒSetting a Databricks Connector
            • ๐Ÿ”ŒSetting up a ElasticSearch Connector
            • ๐Ÿ”ŒSetting up a Clickhouse Connector
          • ๐Ÿ”ŒOnline services connectors
            • ๐Ÿ”ŒSetting up a Sharepoint Connector
            • ๐Ÿ”ŒSetting up a Google Sheets Connector
            • ๐Ÿ”ŒSetting up a Salesforce Connector
            • ๐Ÿ”ŒSetting up a Hubspot Connector
          • ๐Ÿ”ŒSetting up an AWS S3 connector
      • ๐Ÿ—„๏ธManaging remote file storages
        • ๐Ÿ—‚๏ธSetting up a file storage
          • SFTP
        • ๐Ÿ“„Create a dataset from a file
      • ๐Ÿ“Managing Files
        • ๐Ÿ“Adding, editing and deleting local files
        • ๐Ÿ“‚Using advanced file settings
        • ๐Ÿ“Adding and combining remote files in Toucan
    • ๐Ÿ”ขDatasets in Toucan
      • ๐Ÿ”ขStored and Live Datasets
      • ๐Ÿ’ฟManaging datasets
        • ๐Ÿ”ขCreating datasets
        • ๐Ÿ”ขEditing, Duplicating and Deleting a dataset
        • ๐Ÿ”ขRefreshing and Publishing Datasets
        • ๐Ÿ“ˆOptimize data performance
        • ๐Ÿ—‚๏ธAdding indexes to stored datasets
        • ๐Ÿ‘ฉโ€๐Ÿ’ปCode mode and single mode
      • ๐Ÿ›‘Setting permissions on dataset
      • ๐Ÿ—ƒ๏ธMaintaining Data
        • ๐Ÿ—ƒ๏ธTagging datasets
        • ๐Ÿ—ƒ๏ธIdentifying datasets dependencies
        • ๐Ÿ—ƒ๏ธSet validation rules
    • ๐Ÿง‘โ€๐ŸณPreparing data
      • Overview of YouPrepโ„ข
        • ๐ŸŽนColumn header
          • Rename column
          • Duplicate column
          • Fill null values
          • Replace values
          • Sort values
          • Convert columns data types
        • Add
          • Add text column
          • Add formula column
          • Add conditional column
        • Filter
          • Delete columns
          • Keep columns
          • Filter rows
          • Top N rows
          • ArgMax
          • ArgMin
        • Aggregate
          • Group by
          • Add total rows
          • Hierarchical rollup
          • Get unique groups/values
        • Compute
          • Compute evolution
          • Cumulated sum
          • Percentage of total
          • Rank
          • Moving average
          • Compute statistics
          • Absolute value
        • Text
          • Concatenate
          • Split column
          • Extract substring
          • To lowercase
          • To uppercase
          • Compare text columns
          • Trim spaces
          • Replace text
        • Date
          • Convert text to date
          • Convert date to text
          • Extract date information
          • Add missing dates
          • Compute duration
          • Normalize date granularity
        • Reshape
          • Pivot
          • Unpivot
          • Waterfall
        • Combine
          • Append datasets
          • Join datasets
        • Geo
          • Geographic dissolve
          • Geographic hierarchy
          • Geographic simplify
          • Prepare geo data (with basemap)
      • YouPrepโ„ข Native SQL
      • Hybrid pipeline
    • โžฟManaging variables in Toucan
      • โžฟVariables hub
      • โ™ˆUse variables in YouPrepโ„ข
      • โžฟEasy reference to variables
    • ๐ŸงžUsing advanced data concepts
      • ๐ŸงžData personnalisation with user attributes
        • Connector setup with a user attribute
        • Database selection with a user attribute
        • YouPrep data filtering with a user attribute
        • Filter data in SQL with a user attribute
      • ๐ŸงžAdvanced syntax for variables
      • ๐ŸงžData cache
  • Visualizations and Layouts
    • ๐Ÿ“บApps
      • ๐Ÿ“บManaging Apps
        • โž•Creating Apps
        • ๐Ÿ“„Duplicating Apps
        • ๐Ÿ–จ๏ธPublishing Apps
        • ๐ŸšฎDeleting Apps
        • โœ๏ธEditing within an App
      • ๐Ÿ–Œ๏ธCustomizing Apps
        • Customizing chart color elements
        • Customizing the app's font
        • Adding Assets
        • Adding Glossary
        • Setting up, Managing and testing custom visibilities
        • Customizing the "no data error" message
        • Creating a dynamic background based on an Filter's column
      • ๐Ÿ Home
        • Creating the Home
        • Creating Tiles
          • Tile Dynamic Value
          • Tile Leaderboard
          • Tile Line
          • Tile Scorecard
          • Tile Bullet
          • Tile Heatmap
          • Tile PDF
          • Tile Video
          • Tile Image
          • Tile Text
          • Tile HTML
          • Tile Separator
      • โœจStories
        • Creating a Story
        • KPIs
        • Narrative
        • Crossfilter
      • ๐Ÿ“ฝ๏ธFilters
        • Managing Filters
          • Creating, reusing and editing Filters
          • Applying Filters
          • Unpinning and deleting Filters
        • Type of Filters
          • Dropdown
          • Checkboxes
          • Buttons
          • Date Range
          • Hierarchical
          • Slider
        • Templating from Filters' values
        • Dependant Filters
      • ๐Ÿ“ˆPDF Report
      • ๐ŸŽกDatawall
      • ๐Ÿ—๏ธDashboard Builder
        • Create a Dashboard Builder
        • Embed a Dashboard Builder
        • Dashboard export options
      • ๐ŸŒŸMyFavorites
    • ๐Ÿ“ŠCreating Visualizations
      • ๐ŸคฉViz Gallery
        • Barchart
        • Barlinechart
        • Bubblechart
        • Bulletchart
        • Circularchart
        • Funnelchart
        • Gantt chart
        • Heatmap
        • HTML
        • Leaderboard
        • Leaderboard Centered Average
        • Linechart
        • Mapchart
          • Configure a drill
        • Mediachart
        • Radarchart
        • Tablechart
        • Timeline
        • Versuschart
        • Waterfallchart
        • Score Card
        • Stacked Barchart
      • ๐Ÿง Common Chart Configuration
      • ๐Ÿ’…Customizing chart colors
      • ๐Ÿงžโ€โ™‚๏ธAdvanced chart configuration
        • Templating from chart's dataset
        • Add units, precisions and sentiments
        • Adding Tutorials
        • Add sparklines
        • Navigate with stories
        • Group informations in your stories
        • Multiple charts in one story
        • Manage dates
        • Customize tiles' sources
        • Add stars to tiles' title
        • Manage data order in your tiles
        • Navigate with tiles
    • ๐Ÿ‘ฉโ€๐Ÿ’ปEmbedding
      • ๐Ÿ”Authentication
      • ๐Ÿ–‡๏ธIntegration
        • Generate and manage embeds
        • Customize embeds
        • Embedding a Toucan App Using iFrames
        • Passing Extra Variables to Your Toucan Embed
      • โš™๏ธEmbed SDK
        • Embed SDK Authentication
      • โ“FAQ
    • ๐Ÿ™‹Self-Service
      • Self-Service Dashboard
      • Self-service PDF Report
  • Collaboration
    • โฐCreating alerts
    • ๐Ÿ“งManaging notifications
    • โž•Enriching a story with descriptions
    • ๐Ÿ’ŒSharing content
    • ๐Ÿ’ฌAdding comments to stories
  • Administration
    • Page
    • โš™๏ธInstance Management
      • โš™๏ธManaging operations in SaaS
      • โš™๏ธCustomizing your instance (whitelabel)
    • ๐Ÿ‘ฅManaging Users
      • ๐Ÿ‘ฅUsers
      • ๐Ÿ‘ฅManaging user groups
      • ๐Ÿ‘ฅManaging user properties
      • ๐Ÿ‘ฅSetting up permissions and visibilities
    • ๐ŸŒManaging languages in Toucan (internationalisation)
    • ๐Ÿ“ˆMonitoring Engagement with User Analytics
      • ๐ŸŽ›๏ธHow to Filter your User Analytics?
      • ๐Ÿ–ฅ๏ธUnderstanding your User Analytics Dashboards
  • Additional Ressources
    • ๐Ÿ“šExternal documentation
    • ๐ŸšSupport for App-builders
    • ๐Ÿ†•Latest releases
      • ๐ŸŽ2025 Releases
      • ๐ŸŽ2024 Releases
      • ๐ŸŽ2023 Releases
    • ๐Ÿ”งTroubleshooting
      • Troubleshoot:: DataHub
      • Cross-Site Cookies
      • How to :: read the inspector error
      • How to :: troubleshoot the toucan way
Powered by GitBook
On this page
  • โœจ New Chart Design Available
  • Purpose & Application
  • Key features
  • Configuration

Was this helpful?

  1. Visualizations and Layouts
  2. Creating Visualizations
  3. Viz Gallery

Heatmap

Last updated 3 months ago

Was this helpful?

โœจ New Chart Design Available

What's new?

  • Interactive Legend with Filterable Checkboxes

  • Consistent Data Labels Hover

  • Enhanced Tick Management & Zoom Tool


Purpose & Application

The heatmap helps you acquire a global vision on combining several indicators and entities. It is also ideal for cutting through data.

The heatmap is good for comparison. Use the heatmap to get an overview of whatโ€™s happening across a large number of metrics and dimensions. Each value represents the intersection of the the x-axis and the y-axis. You can also add a secondary value (for instance variation vs last period).

๐Ÿ“ For example, I want to see all my industrial KPIs by production sites

A heat map visualizes data through color variations. As a matter of fact, this graph is useful for cross-referencing a variety of data, placing variables in rows and columns, and coloring cells in the table.

Heat models are quite effective to show variations between multiple variables. It acts by revealing all the models available, showing forth similarity between variables, and detecting any possible correlations between them.

Info

You have the option to display complementary information within the legend. Very useful if you want to compare performances to the target for example! ๐ŸŽฏ

Key features

  • Subvalue will allow you to display a complementary information within cells in the table. This way, you can focus on whatโ€™s important for you : market share & ranking, sales & variationโ€ฆ every analysis is possible!

  • Xorder and yorder will give you the opportunity to choose the order the information is displayed. It can be helpful if you want to focus first on something specific! ๐Ÿ”

  • Packs will help you vizualize groups or categories that you want to analyze together.

Configuration

New Chart Design

*Mandatory parameters

Section
Option
Configuration tutorial

Dataset*

Select the dataset used by the chart

X axis (columns)*

Select the column corresponding to the abscissa

Y axis (rows)*

Select the column corresponding to the ordinate

Value*

Select the aggregation to use, and the column on which the aggregation will be applied for you value (Intersection of your breakdowns)

Sort

X order

(By default, alphabetical order) Check the box "X order" Select the configuration type and the Order (column to use for ordering)

Sort

Y order

(By default, alphabetical order) Check the box "Y order" Select the configuration type and the Order (column to use for ordering)

Enrich chart

Second value

Check the box. Select the column to display as second value, and the aggregation.

Enrich chart

Additional info

(The target value will be displayed only in the Legend) Check the box "Target" and select the column corresponding the the target

Display

Display all values and subvalues

Check the box

Display

Rectangle height (in pixels)

Enter the square height in pixels (caped at 40px on mobile)

Display

Rectangle width (in pixels)

Enter the square width in pixels (caped at 40px on mobile)

Tutorial

ID

Enter an ID.

Change the ID to display the tutorial again.

All tutorials with the same ID will be displayed only once.

Tutorial

Message

Enter your message. This will be displayed to your users

Tutorial

Always show this tutorial

By default the tutorial is shown once only

*Mandatory parameters

Section
Option
Configuration tutorial

Dataset*

Select the dataset used by the chart

X axis (columns)*

Select the column corresponding to the abscissa

Y axis (rows)*

Select the column corresponding to the ordinate

Value*

Select the aggregation to use, and the column on which the aggregation will be applied for you value (Intersection of your breakdowns)

Legend

Display legend

Click on the toogle to use legend

Legend

Default selection -> Default selected column

(The display legend option should be activated for this one)

Check the box "Default selection", then "Default selected column" Select the configuration type

Legend

Default selection -> Default selected row

(The display legend option should be activated for this one)

Check the box "Default selection", then "Default selected row" Select the configuration type

Legend

Additional info

(The display legend option should be activated for this one)

Check the box "Additional info" Select a column and an aggregation for additional infos to display in the legend

Legend

Select intersection on hover

(The display legend option should be activated for this one) Click on the toogle to activate this option

Sort

X order

(By default, alphabetical order) Check the box "X order" Select the configuration type and the Order (column to use for ordering)

Sort

Y order

(By default, alphabetical order) Check the box "Y order" Select the configuration type and the Order (column to use for ordering)

Packs

X Packs

Check the box "X Packs" and select the column containing informations about grouping label

Packs

Y Packs

Check the box "Y Packs" and select the column containing informations about grouping label

Packs

Display Pack names

Click on the toggle "Display pack names"

Packs

X packs order

(By default, alphabetical order)

Check the box Select the configuration type Select the column to use for ordering

Packs

Y packs order

(By default, alphabetical order)

Check the box Select the configuration type Select the column to use for ordering

Enrich chart

Second value

Check the box. Select the column to display as second value, and the aggregation.

Enrich chart

Target

(The target value will be displayed only in the Legend) Check the box "Target" and select the column corresponding the the target

Display

Display all values and subvalues

Check the box

Display

Square's transparency

Check the box Select the column to be based on to determine transparency level

Display

Square height (in pixels)

Enter the square height in pixels (caped at 40px on mobile)

Display

Square width (in pixels)

Enter the square width in pixels (caped at 40px on mobile)

Display

Y Label width (in pixels)

Enter the square width in pixels (caped at 100px on mobile)

Display

Display Y axis dots

Click on the toogle in order to display dots between the label and squares

Display

Size

(Used only for multiple charts)

Enter a proportion of the total screen between 0 and 1

Display

Mobile size

(Used only for multiple charts)

Enter a proportion of the total screen between 0 and 1 for mobile screens

Display

Custom CSS class

Set a custom CSS class to target this specific chart with CSS

Tutorial

ID

Enter an ID.

Change the ID to display the tutorial again.

All tutorials with the same ID will be displayed only once.

Tutorial

Message

Enter your message. This will be displayed to your users

Tutorial

Always show this tutorial

By default the tutorial is shown once only

๐Ÿ“Š
๐Ÿคฉ
Streamlined Smart Editor Options