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
        • ✨New Viz Designs
          • Barchart
          • Barlinechart
          • Bubblechart
          • Circularchart
          • Heatmap
          • Leaderboard
          • Linechart
          • Stacked Barchart
          • Tablechart
        • 📁Legacy Viz Designs
          • Bulletchart
          • Funnelchart
          • Gantt chart
          • HTML
          • Leaderboard Centered Average
          • Mapchart
            • Configure a drill
          • Mediachart
          • Radarchart
          • Timeline
          • Versuschart
          • Waterfallchart
          • Score Card
      • 🧠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
        • The embedded Self-Service Dashboard
        • The in-platform Self-Service Dashboard
      • Self-service PDF Report
  • Collaboration
    • ⏰Creating alerts
    • 📧Managing notifications
    • ➕Enriching a story with descriptions
    • 💌Sharing content
    • 💬Adding comments to stories
  • Administration
    • ⚙️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
  • 🧭 Overview
  • ⭐ Key Features
  • Configuration

Was this helpful?

  1. Visualizations and Layouts
  2. Creating Visualizations
  3. Viz Gallery
  4. New Viz Designs

Heatmap

Last updated 15 days ago

Was this helpful?

🧭 Overview

A heatmap is a graphical representation of data where individual values are represented by color. It helps users quickly identify patterns, correlations, and outliers across two categorical dimensions (X and Y axes). Heatmaps are particularly useful when analyzing dense datasets or when you want to present values in a visually compact and intuitive format.

📊 Example Use Case

  • Comparing user engagement levels across different features and time periods

  • Analyzing performance metrics across departments and teams

  • Tracking bug frequencies by category and priority level

  • Visualizing correlation matrices for statistical analysis

  • Monitoring server load across regions and time intervals


⭐ Key Features

  • Add secondary cell value: Go beyond just visualizing numbers—add a complementary value to each cell to provide deeper context. Whether it’s displaying percentage change, confidence intervals, or notes, this feature helps users interpret the data more accurately and make informed decisions faster.The heatmap helps you acquire a global vision on combining several indicators and entities. It is also ideal for cutting through data.

Configuration

Learn how to create a heatmap using the new design with this step-by-step guide. Explore the interactive walkthrough below to get started quickly, then dive into the full configuration reference table for in-depth details.

Chart Configuration Step-by-Step

Option
How does it work?

Dimension

Column X-Axis

Select the data column to be displayed on the X-axis (horizontal).

Order columns

Define sort order for X-axis values (column based or custom).

Reverse column order

Invert the order of X-axis labels.

Measure

Row Y-Axis

Select the data column to be displayed on the Y-axis (vertical).

Primary cell value

Specify the main value to be visualized via color intensity.

Precision

Precision determines the level of detail in how your values are displayed. By default, measures use a .2f format, meaning they are shown with two decimal places.

Example: A value of 3.14159 will be displayed as 3.14 when using .2f formatting.

Unit

Unit represents the total quantity or category being measured for a KPI. It defines what the values correspond to, providing context for better interpretation.

Sentiment

Four different sentiment statuses (positive, warning, negative, neutral) can be used to color bars, enhancing visual distinction.

Note: Sentiments can be customized in the app theme.

Add secondary cell value

Include an optional second value (e.g. shown on hover or as a label).

Order rows

Define sort order for Y-axis values (column based or custom).

Reverse row order

Invert the order of Y-axis labels.

Additional parameters

ID

Unique chart Id

Add complementary value

The complementary value is displayed in the data label, providing additional context and making it easier for viewers to interpret the data at a glance. It is possible to add a precision, an unit and a sentiment.

Add user chart guide

Lead your chart viewers through the narrative of your data.

Chart performance

Technical performance

Style Configuration

Option
How does it work?

Cell height

Sets the vertical size of each cell in pixels. Default: 60 px.

Cell width

Sets the horizontal size of each cell in pixels. Default: 60 px.

This page provides a step-by-step guide for creating a barchart using the legacy 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)

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

📊
🤩
✨