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
  • Purpose & Application
  • Key features
  • Configuration

Was this helpful?

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

Mapchart

Last updated 1 year ago

Was this helpful?

Purpose & Application

The mapchart is the best chart to display geographic disparities.

This chart is good to compare values of different areas.

📝 For example, the GDP per countries in the world.

The zones can be geographic regions or different areas of a commercial center.

📝 For example, the average basket of the stores of a commercial center.

It can also be used to locate cities or buildings on a map using markers.

In order to create a mapchart, the dataset must include a geographical column (detected automatically by Toucan).

Key features

What makes this graph a killer story?

  • 📌 Markers make it easy to highlight specific points such cities for example and thanks to the color legend, we can see at a glance from which countries they depend.

In our case I can clearly tell that Paris, Lyon and Strasbourg contributes to France GDP 📈

  • 🗺️ Custom base map allows you to display whatever you want! It can be the world, areas, countries, cities, neighborhood and even floor plans of a shopping mall -great to analyze which shops are the most visited and if those shops are located close to each other

In our case I can zoom in Italia and quickly tell how zones are performing. Wooow! 4 areas have a very high GDP : Piemonte, Lombardia, Toscana, Sardegna, Sicilia 🤩

  • ⚙️ Crossfilter functionality allows you to use your map chart as a master with another viz! It can be a horizontal bar chart, a stacked bar one, etc.

  • 🔎 Smooth drill functionality makes it easy on the eye, your user will love it! Add a drill to your mapchart to go in a deeper level of detail.

How easy it is to get the Africa GDP then see the details for each country! 🌍

  • Compatible and optimized mobile display, get your data anywhere 📱!

Configuration

*Mandatory parameters

Section
Option
Configuration Tutorial

Dataset*

Select the dataset used by the chart

Zone

Color zones

This allows to apply a color in geographical zones depending on a value. Configure the fields (mandatory: Label and Color value)

Zone

Color zones / Label

Select the column contaning zone labels

Zone

Color zones / color value

Select the column contaning zone colors

Zone

Color zones / Default selected zone

Enter the default selected zone among "first", "last" or the label within the dataset

Zone

Color zones / Zone opacity

Enter the opacity value between 0 and 1 (0 is completely transparent, the default value is set as 1)

Zone

Color zones / Use scaling on unfiltered dataset

Activate the option by clicking on the toogle

Zone

Color zones / Number of scale's buckets

Enter the number of buckets for the scale

Zone

Color zones / Display values on zones

Activate the option in order to display values on zones

Zone

Color zones / Custom color thresholds

Check the box Add threshold value(s) (limited at 3)

Zone

Color zones / Additional info

Check the box Select column(s) of the dataset containing additional info

Zone

Color zones / Scale

Check the box Customize color by clicking on it You can also add new bounds

Zone

Color zones / Reverse scale

Activate this option to set high values as cold and low ones as hot

Zone

Color zones / Missing data zones

Manage the display of zones with no data

Markers

Markers

It allows to apply markers (circle) on some location based on latitude, and longitude. Configure the fields

Markers

Markers / Latitude

Select the column containing latitude coordinates

Markers

Markers / Longitude

Select the column containing Longitude coordinates

Markers

Markers / Label

Select the dataset's column containing markers label

Markers

Markers / Markers color

Select the dataset's column contaning markers color

Markers

Markers /Markers size

Check the box Select the configuration type Customize the size according the configuration type

Markers

Markers / Opacity

Enter the opacity value between 0 and 1 (0 is completely transparent, the default value is set as 1)

Markers

Markers / Additional info

Check the box Select column(s) of the dataset containing additional info

Markers

Markers / Default selected marker

Enter the default selected marker among "first", "last" or the label within the dataset

Markers

Markers / Recycle groups colors

Activate the option to recycle groups colors when chart data changes

Legend

Display legend

It allows to display a legend on the right part of the chart. Click on the checkbox. (You can display the legend of all labels by activating the option "Use exhaustive legend")

Map Background

Background

It allows to display a map as a background. Click on the checkbox Click on the checkbox "Background type" and select the type of background

Map Background

Projection

Display

Fixed Map

Activate the option the option to prevent user from zooming within the map

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

In order to create a mapchart, the dataset used must contains a geographical column (that will be automatically detected and used). Look at this to have more information on how to prepare the dataset for this purpose.

This is an advanced option (know more about map projection ). By default, the Mercator projection () is assumed. If geographical coordinates in your data are already projected on a plan, set the projection option to the value "plan".

📊
🤩
📁
documentation
here
WGS 84
Before the drill
After drilling on North of Africa