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
  • ✨ New Chart Design Available
  • Purpose & Application
  • Key features
  • Configuration

Was this helpful?

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

Leaderboard

Last updated 3 months ago

Was this helpful?

✨ New Chart Design Available

What's new?

  • Drill-Down Feature

  • Crossfilters

  • Interactive Legend with Filterable Checkboxes

  • Enhanced Tick Management & Zoom Tool


Purpose & Application

A leaderboard shows ranking among categories. It consists of a series of bars representing a quantitative metric for comparable entities. This viz allows to quickly benchmark all entities.

📝 For example, I want to know which of my regions is performing best?

The leaderboard is good when there are more than 10 categories to compare.

It can also help compare up to 3 KPIs for each of these categories.

Key features

What makes this chart a killer story?

  • On the fly ranking! You have to click on the arrow to filter according to the variation, otherwise you might miss it. It’s good to see best/worst performer for a given period, but what about identifying the best/worst evolution from last period? With our smooth UX, you’ll see right away the ranks changes.

France is my top selling country in 2019, but is only improving by 0.001% versus last year, while Germany is progressing: +36.6% versus last year.

  • Smooth drill functionality to get a deeper level of analysis 🔎.

  • Average column can be used to make a vertical line appear, so that you can compare your bars to the overall average.

My best shop has sold 300K€ of cheese this year, how is it going comparing to the average of all my different shops?

  • Sparklines are the variation end-game boss ⚔️. It allows you to show your user a X years / months / whatever evolution as a sparkline on the right side of each bar.

I want to have a global vision of the performance of Bordeaux’s 🍷 shop, right from its opening.

  • Colors coding add some colors to your chart 🎨 which can be a great way to help decision makers to focus on what’s important.

I have several shops by region, and I want to be able to have both an overview and a drill down option.

  • Additional values are available for both single bars or groups, and allows your App Builder to display complementary informations within the legend of the leaderboard.

I’ve sold 200K€ of candies 🍭 in 2019, but what is the associated margin? I can add it as an additional value that will be displayed when the user will click on a bar.

Configuration

New Chart Design

*Mandatory parameters

Section
Option
Configuration Tutorial

Dataset*

Select the dataset used by the chart

Label*

Your label of choice

Value*

Your value of choice

Sort

Sort Bars

Select ascending or descending order

Sort

Display Rank For Sorted Bars

Display the rank of each sorted bars

Groups

Groups

Breakdown labels into groups based on a column containing the groups

Groups

Groups Order

Order group based on a column, on an advanced order or a custom order

Drill

Drill

Click on labels and see children details

Enrich Chart

Additional Info

Display additional values next to the main one (will not be displayed on mobile)

*Mandatory parameters

Section
Option
Configuration Tutorial

Dataset*

Select the dataset used by the chart

Label*

Your label of choice

Value*

Your value of choice

Legend

Display Legend

Toggle the legend display

Legend

Additional Info

Display contextual in-depth info

Legend

Bar Selected By Default

Select a bar by default

Sort

Sort Bars

Select ascending or descending order

Sort

Display Rank For Sorted Bars

Display the rank of each sorted bars

Variation

Variation

Display a variation badge next to the value based on a column containing the variations

Variation

Variation Legend

Display a legend for your variation

Variation

Hide Empty Variation

Hide variation badge if the value is empty

Groups

Groups

Breakdown labels into groups based on a column containing the groups

Groups

Groups Order

Order group based on a column, on an advanced order or a custom order

Groups

Groups Additional Info

Add a legend to your groups

Groups

Recycle Groups Colors

Reuse groups colors when chart data changes (filters changes for example)

Packs

Packs

Group labels together based on a column

Packs

Display Pack Names

Display or not the packs names

Packs

Packs Order

Order pack based on a column, on an advanced order or a custom order

Drill

Drill

Click on labels and see children details

Drill

Drill Children Order

Order children based on a column, on an advanced order or a custom order

Enrich Chart

Average

Add a vertical average bar based on a value or a column

Enrich Chart

Average Legend

Display a legend for your average bar

Enrich Chart

Additional Values

Display additional values next to the main one (will not be displayed on mobile)

Enrich Chart

Target

Represent target but use it with caution as it is preferable to use the bullet tile to represent targets

Enrich Chart

Sparklines

See the Sparklines section

Display

Scale

Define the bars scale using two bounds

Display

Size

Define the chart size when having multiple ones

Display

Mobile Size

Define the chart size when having multiple ones on mobile

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 display this tutorial

By default the tutorial is shown once only

📊
🤩
Streamlined Smart Editor Options