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
  • Tag
  • Value
  • Variation
  • Comment
  • Bullet
  • Link
  • Image

Was this helpful?

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

Tablechart

Purpose & Application

Very useful when you have a lot of different metrics and dimensions to present all together. Indeed, use it to display a mix of quantitative and qualitative information.

📝 For example, I want to see detailed information about my products : reference, images, sold units on stocks, instagram posts etc…

I am a business manager, and I need to sum up all the information regarding my business in 1 chart.

I will use Toucan Toco’s upgraded version of a tablechart with :

  • performance tags on values

  • images

  • clickable url links

  • bulletchart

  • colored tags

  • readable text

Key features

What makes this chart a killer story?

  • Images: to illustrate your data with a picture 🖼️! An image worth a thousand words.

As a marketing manager, I want to see an image of the packaging of the products presented in my performance review in the tablechart.

  • Url links: to go further in the analysis 🌐. They will take you anywhere : in another website or to another chart in the Toucan application.

As a social media manager, I have a review containing the 10 most liked post on instagram. I want to click on the post link to be redirected to instagram and see/read the post.

  • Tags: to categorize the data and related information.

As a social media manager, I want to easily see the posts by social media. Hopefully, the colored tags help me to see which ones are from instagram, facebook and twitter.

  • Integrated bulletchart: to get a better vision of the realised vs target figures 🎯.

As a social media manager, I want to monitor the total reach vs what was expected.

  • Compatible and optimised mobile display, read your chart from anywhere!

I just arrived in London, I’m in the cab, I can check my data one last time before the meeting.

Configuration

* Mandatory paramers

Section
Option
Configuration tutorial

Dataset*

Select the dataset used by the chart

Columns*

Display

Rows Per Page

Allows to increase numbers of rows for each page

Display

Row Color Coding

Apply a color on the full row based on data column

Display

Row Height

In px. Determine the height of rows

Display

Hide Headers

Hide the headers of the table

Display

Hide Search

Remove the possibility to search on unique values

Display

Make First Column Sticky

Make the first column sticky when we scroll horizontally

Display

Size

Define the chart size when having multiple ones

Display

Mobile Size

Define the chart size when having multiple ones on mobile

Display

Compact Rows

Display the rows with a decrease height in order to optimize display. It also compact tags & images

Display

Total Rows

Display a new row that sum columns based on the data type. On numbers, Toucan makes a "sum", on other types, Toucan makes a "count".

Display

Custom CSS Class

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

Tutorial

Tutorial

Set a tutorial to help your users to understand the chart by giving him an id and a message

Tag

This column type is like a label since each value has a given color. This makes it a great way to visually see patterns and commonalities.

Option
Description

Tag Text

Select the column containing the text to display

Tag Color

Select a column containing values that groups label together. They will be segregated by groups with different series colors.

Column Width

In px. Determine the width of the column.

Date Format

Customize date format when your "Tag text" is a Date.

Use Uniform Color

Deactivate color affectation on tags. Will result with neutral (grey) color.

Group

Display the column as a sub-column in a groups of columns.

Value

This column type is perfect to display numbers.

Tip

Option
Description

Value

Select the column containing the value to display

Variation

Select the column containing a meaningful variation (ex: evolution vs. N-1)

Value alignement

Determine whether to align the value on the left, on the center or the right. By default, it's centered.

Column Width

In px. Determine the width of the column.

Display Sentiment

Display the sentiment on the figure if one is configured on the "value" field.

Sentiment Display Type

Choose whether if the sentiment is displayed on the text or on the cell. On the text by default.

Group

Display the column as a sub-column in a groups of columns.

Variation

This column type is perfect to display an evolution.

Option
Description

Variation

Select the column containing a meaningful variation (ex: evolution vs. N-1)

Variation alignement

Determine whether to align the value on the left, on the center or the right. By default, it's centered.

Column Width

In px. Determine the width of the column.

Group

Display the column as a sub-column in a groups of columns.

Comment

This column type is perfect to display long text.

Note

By default, Toucan will place quotes around the comment. In this case, we’ll remove the comments by making sure the ADD QUOTES option is turned off.

Option
Description

Text

Select the column containing the text to display.

Text alignement

Determine whether to align the value on the left, on the center or the right. By default, it's centered.

Column Width

In px. Determine the width of the column.

Add quotes

If turned off, quotes will disppear.

Group

Display the column as a sub-column in a groups of columns.

Bullet

This column type is useful to display objectives with target within a tablechart.

Option
Description

Value

Select the column containing the value to display

Target

Select the column containing the target to reach

Column Header

Fill the table column header with text.

Overwrite Automatic Sentiment

Select the column to override the default sentiment rules (value over target)

Use Same Scale for All Bars

Enable to use the same scale across all bars within the tablechart. False by default.

Group

Display the column as a sub-column in a groups of columns.

Link

This column type is useful to display and format URLs for interactive tablechart.

Option
Description

URL

Select the column containing URLs

Link Name

Select the column containing a meaningful text for the given URLs

Text alignement

Determine whether to align the text on the left, on the center or the right. By default, it's centered.

Column Width

In px. Determine the width of the column.

Group

Display the column as a sub-column in a groups of columns.

Image

This column type is useful to display images within the tablechart.

Option
Description

Image

Select the column containing image path (either a URL or name of the asset in Toucan)

Image type

Select the type according to the image you want to display. "Asset" is an image hosted in Toucan and "External" is an image hosted on the web, accessible with an URL.

Image Size

Select the display size between "small", "medium" and "large. "Small" by default.

Column Width

In px. Determine the width of the column.

Group

Display the column as a sub-column in a groups of columns.

Last updated 1 year ago

Was this helpful?

Cf. next tables for more information on column types (, , , , , , )

Always add to have a perfect display!

📊
🤩
precision
Tag
Value
Variation
Comment
Bullet
Link
Image