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

Was this helpful?

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

Bubblechart

Purpose & Application

Bubblecharts are generally used to compare and show the pattern and correlation between labels and categories, through positioning and proportions.

📝 For example, I want to compare my Business units across sales, margin and market share

Use the axis for the 2 most important metrics and the bubble size for the last one.

Key Features

  • Easy-to-configure zones make identifying best/worst performers easy without even reading the axis 💯.

  • Smooth drill functionality to get a deeper level of analysis without overloading the graph with too many bubbles

  • Colors to identify ensembles in the chart among the bubbles 🎨.

Configuration

*Mandatory parameters

Section
Option
Configuration tutorial

Dataset*

Select the dataset used by the chart

X axis*

Column containing x axis value

Y axis*

Column containing y axis value

Legend

Display legend

Toggle to activate legend display

Legend

Additional info

Add another column for more information on the legend

Legend

Default selected bubble

Choose the first, last or the name of the label

Legend

Display a color gradient legend

Toggle to display a color gradient legend

Legend

Modify gradient color

Enter the min and max color (HEX (‘#…’) code)

Drill

Drill

The first bubble you see is the parent bubble.

Click on it to see it’s children

Drill

Level

Column containing parent or child level information

Drill

Group

Column containing the name of the parent bubbles to group them

Drill

Levels order

Enter the value of the parent bubbles as the 1st entry and the level value of the child bubbles as 2nd entry

Colored Zone

Quadrants

Divide your bubble chart in 4 colored zones

Colored Zone

Quadrants - Configuration type

Select the configuration type for quadrant:

  • hardcoded: static position of the quadrant

  • dynamic: depending on values within the dataset

  • from decile: typing figures between 1 to 10 to automatically divide the chart

Colored Zone

Quadrants - X

Column containing x axis value

Colored Zone

Quadrants - Y

Column containing y axis value

Colored Zone

Color coding

Add a color coding in the zones Input Order (4 max): top left, top right, bottom left, bottom right

Colored Zone

Quadrant legend

Add a legend in the zones Input Order (4 max): top left, top right, bottom left, bottom right

Colored Zone

Bisector

Divide your chart in 2 zonesDon’t forget to add a color coding and a legend!

Colored Zone

Bisector X axis

Column containing x axis value

Colored Zone

Bisector Y axis

Column containing y axis value

Colored Zone

Bisector - Color coding

Add a color coding in the zones Input Order (2 max): top left & bottom right

Colored Zone

Bisector - Zones legend

Add a legend in the zones Input Order (2 max): top left & bottom right

Enrich Chart

Bubble size

Column containing bubble size value

Enrich Chart

Bubble color

Column containing bubble color value/category: it can be a number or a text

Enrich Chart

Line

Add a line on top of your bubble chart to display an average, an objective of revenue...

Enrich Chart

Line - X axis

Column containing x axis value

Enrich Chart

Line - Y axis

Column containing y axis value

Display

Display bubbles' values

Toggle to display the value on the bubbles

Display

X axis scale

Use it to define the scale for the X axis: choose 2 bounds (if you’re displaying %, use bounds between 0 and 100)

Display

Y axis scale

Use it to define the scale for the Y axis: choose 2 bounds (if you’re displaying %, use bounds between 0 and 100)

Display

Bubble size scale

Use it to define the bubbles size scale: choose 2 bounds (if you’re displaying %, use bounds between 0 and 100)

Display

Overwrite default bubble's opacity

Display

Recycle bubbles colors

Reuse bubbles color when chart data changes (filters or requesters).

Display

Zoom

Toggle to enable zoom

Display

Overwrite the default min and max zoom of [1, 5]

Input a value from 1 to 5 to set a default zoom on the chart

Display

Size

Enter a proportion of the total screen (a number from 0 to 1)

Use on multiple charts only

Display

Mobile size

Enter a proportion of the total mobile screen (Use on multiple charts only): enter a number from 0 to 1

Display

Custom CSS class

Set a customm 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

Last updated 1 year ago

Was this helpful?

📊
🤩