Off the Charts
Get Started Free
Off the Charts
Chartio Help Center
How can we help you today?
Advanced Data Pipeline
All Help Center Articles
Advanced mode Pipeline view
Add country names to your maps
Adding link titles in table charts
Axis label format
Bar charts and Line charts
Build a Dynamic Bar Chart to Compare Time Periods
Adding a totals row to a table chart
Can I change the join path that's generated in Interactive Mode?
Can I clone a dataset?
Can I hide a chart's legend?
Can I add clickable URLs to my dashboard?
Change your table chart's font size
Changing chart types
Chart data limits
Column formatting in table charts
Create dynamic titles
Date formatting in a chart
Different colored bars in a bar chart
Downloading a chart
Dual axis line charts with three or more lines
Editing in SQL and Interactive Modes
ERROR: canceling statement due to user request
ERROR: function to_char(unknown, unknown) is not unique
Explore chart data feature
Filtering by complete days
Formatting x-axis date labels
Helpful chart settings
How are weeks defined in Chartio?
How do I get rid of decimal places on my chart?
How do I link directly to a chart?
How to add a target line to your chart
How to compare a date against the previous weekday using a dashboard filter
How to compare data year over year
How to create week dimensions that don't start on Monday
How to display unrounded values in chart tooltip
How to Sort Date Buckets Properly
How to use custom colors in your chart
How to View All Rows and Columns
Linear regression line in scatterplot charts
Long text in a Table chart
Measures & Dimensions
Number of lines in a Bar Line chart
Optimizing queries with chart performance analysis
Period over period analysis
Pie chart settings
Pivot with two dimensions and multiple measures (>3 columns)
Query returning inconsistent results
Quick way to create static forecast values - Bar/Line chart
Restarting the Connection Client in non-daemon mode
Row Limit Has Been Reached Error
Set column width in table charts
Sorting Day of Week in a Heat Map
Table formatting for Bar, Line, and Area charts
The Auto chart type feature
Tracking marketing metrics using a funnel chart
Tracking metrics with Conditional Rules
Unstacked Area chart (filled Line chart)
URL text element
Using "Earlier than" and "Later than" as filters
Video tutorial: Adding dimensionality
Video tutorial: Area chart creation
Video tutorial: Bar chart creation
Video tutorial: Bar Line chart creation
Video tutorial: Box Plot chart creation
Video tutorial: Bubble Map chart creation
Video tutorial: Bubble Plot chart creation
Video tutorial: Bullet chart creation
Video tutorial: Funnel chart creation
Video tutorial: Heat Map chart creation
Video tutorial: Line chart creation
Video tutorial: Map chart creation
Video tutorial: Pie chart creation
Video tutorial: Scatterplot chart creation
Video tutorial: Single Value chart creation
Video tutorial: Single Value Indicator chart creation
Video tutorial: Stacked Bar chart creation
Video tutorial: Table chart creation
What does Chartio's Support include?
Why can't I see a column in my table chart?
Cache Priming with Snapshots
Can I add description text or headers to my charts?
Can I add dividers between my charts?
Cloning a dashboard
Creating reference dashboards
Custom dashboard themes
Dashboard size for PDF downloads
Descriptive text and headers for charts and dashboards
Monitor licenses - display your dashboard in full screen
Download a PDF copy of a dashboard
ERROR: The request could not be satisfied.
Getting the most out of a pre-built dashboard
How do I delete a dashboard?
How does caching work?
How to optimize dashboard performance
Making a pacing dashboard
Nested dashboard categories
Report with no recipients
Scheduling email reports
Time zone support in Chartio
Video tutorial: Starting your dashboard
What happens to archived dashboards?
12 Hour Display with "AM" and "PM" Labels
Anti-Join to omit data
Business Vs. Non-Business Hours
Calculate a rolling sum in the Data Pipeline
Calculating Row Number
Can I combine columns together?
Can I combine two fields in the same row into one column?
Combine strings from multiple columns
Combining columns with null value
Common error when applying functions to query results
Compare columns in the Filter Pipeline step
Count Distinct Totals and Percentages
Count keywords in strings
Create a filter based on a more granular time of day range
Dashboard variables in Data Pipeline formulas
Date and Datetime functions in the Data Pipeline
Date and time functions using SQLite
Displaying Seconds as Time
Dynamic dimensions on your dashboard
Example: Get Avg/Month of Count/Day
Extracting parts of a string
Extracting Values from a JSON string in the Data Pipeline
Filter specific days of the week
Find the date difference between rows
Formulas in the Data Pipeline
How can I append characters to my results, or combine multiple columns?
How can I calculate a percentage?
How can I rename a Google Analytics column?
How can I rename the columns and/or names in the chart legend?
How do I change the name of a column?
How do I round numbers?
How to calculate Row Number using the Data Pipeline
How to change a data type in the Pipeline
How to chart a running total
Filtering "is one of" in the Data Pipeline with a Dropdown Variable
How to group email addresses by their domain
How to use the pivot step
How to view the running total
Joining datasets on multiple columns
Null values filtered from result
Troubleshooting percent change
Phone number formatting
Snapshot, trend, and forecast your Salesforce pipeline
Strings in SQLite
Unpivot Data step
Using case statements to set conditional values
Video tutorial: Cloning and the Data Pipeline
Video tutorial: Datasets and Joins
Video tutorial: The Pipeline and Pivot Data
Why is my formula only returning whole numbers?
Zero fill columns
Add new columns to a CSV
Adding notes to your tables using Google Sheets
Google Ads integration
Amazon S3 CSV Integration
Auto foreign key creator
Auto refresh schema
Can I include multiple schemas per data source connection?
Can I limit database access to only certain tables?
Can I use Chartio with a SQL server running on my desktop computer?
Can I use my Google Analytics Custom Segments in Chartio?
Can I use my SSL certificate?
Writing malicious queries
Change a Column's Data Type
Change or swap a data source
Chartio user permissions needed for Amazon Athena sources
Cloud application data in Chartio
Connecting Chartio to database on your local machine
Connecting RDS instance to Chartio
Connecting Salesforce data to Chartio
Connecting to a data source
Connecting to a database within an Amazon VPC
Creating a user with pgAdmin
Creating a user with PSQL
CSV file from Salesforce fails to load
Data discrepancies between Google Ads and Analytics
Direct and partner integrations
Does Chartio affect server performance?
Does Chartio restrict the functions and keywords that can be used in SQL Mode?
Does Chartio store my data?
Does Chartio support Joins across databases?
Does Chartio support MariaDB?
Does Chartio support Unix Time Stamps?
Does the tunnel support proxy?
Edit custom table or column query
Elasticsearch data source
ERROR: Invalid protocol sequence 'P' while in PortalSuspended state.
ERROR: Transaction is read-only.
ERROR: Your database returned: An I/O error occurred while sending to the backend.
Exporting CSV files with double quotes from Excel
Facebook Ads Integration
Foreign key usage
Foreign keys explained
Google Analytics Custom Variables and Dimensions
Google Ads Integration
Google Analytics data source connection
Google Analytics query limit
Google Analytics sampling
Google BigQuery API returned: Not found: Files /gdrive/id/... (HTTP 404 - notFound)
Google Cloud SQL debugging
Google Sheet decimal separator
Google Sheets connection error
Google Sheets - step by step process
Creating a user and granting table level permissions in SQL Server
How datasource time zones work
How do I rename a datasource?
How do I restart the tunnel connection client?
I've made changes to my database, why aren't the changes visible in Chartio?
How often do you run queries against my database?
How to list all available schemas
How to manually add data to Chartio
How to use Google Analytics custom segments in Chartio
Connecting to SQL Server 2008 R2 using SSL
Importing data from an unsupported data source
Improving query performance
Is data from my data warehouse available real-time in Chartio?
Joins across databases
Does Chartio support Joins across Tables?
Limit PostgreSQL user access using schema and views
Multiple data source connections and team views
MySQL SSL connection
MySQL table and column level permissions
Redshift expiring SSL certificate
Repurposing calculations (custom columns)
Restricting data source to Interactive Mode
Searching Charts by Table Query Usage
Select encoding type when opening CSV export in Excel
Stripe data source
TCP/IP connection error
Troubleshooting your SSH Tunnel
Uploading a CSV
Using Google Analytics Goal Metrics (enabling hidden columns)
Using query queues to analyze query performance
VPN and reverse SSH tunnels
Which charts are querying my data source table?
Which charts are using my data source?
Which Google Analytics metrics and dimensions can I query together?
Why are my column names defaulting to lower case?
Aggregating Google Analytics data
Why do some data sources appear as "Unauthorized?"
Data Store Preview
When to use a Chartio data store
Embedding Chartio dashboards
ERROR: This dashboard is too big to embed.
How to determine the height of an embedded Chartio dashboard
Add Chartio as a web app on your iPhone, iPad or Android phone
Can I check my charts on my phone?
Chartio and European data protection requirements
Data Boot Camp
Does Chartio have an API?
Does Chartio have an on-premises solution?
Does Chartio support stored procedures?
Monitor License Guides
Utilizing monitor licenses
Removing your data from Chartio
Sending emails to Slack
Yodeck for displaying dashboards on a monitor
How to change your account name in Chartio
SAML SSO with OneLogin Error
Two factor/multi factor authentication
Types of user licenses
Update payment information
Where can I find a copy of my Chartio invoice?
Can multiple users login using the same Chartio account?
Disconnect your Google Login
Added from dashboard team
Adding new users to your Chartio account
Converting an "Editor" to a "Viewer
Data source access permissions for teams
Deleted/removed user and losing data
How to remove a user from Chartio
Team-based dashboard access
Adding a Measure to a Date Slider
Can I Automatically Apply Variables?
Calculating the last day of the previous month
CASE statements in categorical dropdowns
Changing the date grouping using filters
Combining relative date functions
Current user variable
Defining weeks in Chartio
Dropping Measures into date sliders
Hidden Variables in Drilldown
How to create a drilldown
How to filter on a text box input list with wildcards
Key-value pairs in a Dropdown
OR filters in Interactive Mode
How can I use a range input to filter a chart?
Video tutorial: Adding a control
The Show All setting on dashboard controls
Working with Relative Date Variables
Working with long text fields
Learn why 80% of our Data Heroes use Chartio at least once a day.
Get Started Free