Skip to content
DataSquares
Docs
Search
Ctrl
K
Cancel
Select theme
Dark
Light
Auto
Getting Started
What is DataSquares?
Quickstart
Core concepts
Early access programs
Connect Data
Connector catalog
Connection flows
Troubleshooting
Databases
PostgreSQL
MySQL
MariaDB
SQL Server
Azure SQL
Oracle
CockroachDB
MongoDB
Soon
Cassandra
Soon
Amazon DynamoDB
Soon
Azure Cosmos DB
Soon
Couchbase
Soon
Elasticsearch
OpenSearch
Neo4j
Soon
InfluxDB
Soon
TimescaleDB
ClickHouse
DuckDB
SingleStore
IBM Db2
SAP HANA
Soon
Teradata
Soon
Vertica
Greenplum
YugabyteDB
TiDB
Firebird
Soon
Redis
Soon
Data Warehouses
Snowflake
Databricks
BigQuery
Redshift
Fabric Warehouse
Azure Synapse
Amazon Athena
Trino
Presto
Starburst
Dremio
Soon
Firebolt
Soon
MotherDuck
Cloud Storage & Lakes
Amazon S3
Soon
Azure Blob Storage
Soon
Azure Data Lake Gen2
Soon
Google Cloud Storage
Soon
MinIO
Soon
Delta Lake
Soon
Apache Iceberg
Soon
Parquet Files
SFTP / FTP
Soon
Files & Apps
CSV Upload
SQLite
Google Sheets
Excel Upload
REST API
JSON File
XML File
Soon
OneDrive
Soon
SharePoint
Soon
Dropbox
Soon
Box
Soon
Google Drive
Soon
Business Apps
Salesforce
Soon
HubSpot
Soon
Microsoft Dynamics 365
Soon
Zoho CRM
Soon
Pipedrive
Soon
Stripe
Soon
Shopify
Soon
WooCommerce
Soon
QuickBooks
Soon
Xero
Soon
NetSuite
Soon
SAP ERP
Soon
Workday
Soon
ServiceNow
Soon
Jira
Soon
Asana
Soon
Monday.com
Soon
Airtable
Soon
Notion
Soon
Zendesk
Soon
Freshdesk
Soon
Intercom
Soon
Analytics & Marketing
Google Analytics 4
Soon
Google Ads
Soon
Google Search Console
Soon
Facebook Ads
Soon
Instagram Insights
Soon
LinkedIn Ads
Soon
TikTok Ads
Soon
Bing Ads
Soon
Mailchimp
Soon
Klaviyo
Soon
Mixpanel
Soon
Amplitude
Soon
Segment
Soon
Adobe Analytics
Soon
Developer & APIs
GraphQL
Soon
OData
Soon
SOAP / WSDL
Soon
Webhooks
Soon
GitHub
Soon
GitLab
Soon
Bitbucket
Soon
Sentry
Soon
PagerDuty
Soon
Datadog
Soon
Streaming
Apache Kafka
Soon
Confluent Cloud
Soon
Amazon Kinesis
Soon
Google Pub/Sub
Soon
Azure Event Hubs
Soon
RabbitMQ
Soon
MQTT
Soon
Model Data
Data models & relationships
Calculated fields
Data quality
SquareX
The SquareX guide
Syntax & grammar
Filter context & evaluation
Worked examples
Functions
All functions
Abs
Avg
Calculate
Case
Coalesce
Count
CountDistinct
DateShift
Divide
Fixed
Iif
KeepFilters
Let
Lower
Max
Median
Min
RemoveFilters
RollingSum
Round
Stdev
Sum
Switch
ToText
Upper
Var
YTD
Diagnostics
All diagnostics
SQX001
SQX002
SQX003
SQX004
SQX005
SQX006
SQX007
SQX008
SQX009
SQX010
SQX011
SQX012
SQX013
SQX014
SQX015
SQXW01
SQXW02
Build Dashboards
Canvas basics
Charts & formatting
Visual types
All visual types
Area
Bar
KPI row (block)
Section (block)
Box Plot
Bubble
Bullet
Button
Callout
Column
Combo (Bar + Line)
Divider
Donut
Embed
Date range filter
Dropdown filter
Multi-select filter
Number range filter
Funnel
Gauge
Heading
Heatmap
Histogram
Image
KPI
Line
Link
Map
Pie
Pivot Table
Radar
Sankey
Scatter
Arrow
Ellipse
Line (shape)
Rectangle
Triangle
Sparkline
SQL
Stacked Area
Stacked Bar
Sunburst
Table
Text
Treemap
Waterfall
Filters & interactivity
Exploring dashboards
Metric alerts
Layout & productivity
Themes
Query & SQL
SQL editor
Saved queries
AI
AI chat
AI dashboard generator
Share & Export
Sharing & embeds
Exports
Reports
Administer
Users, roles & invites
SSO & MFA
Settings & operations
REST API
Overview
API Keys
Auth
Dashboards
Data Sources
Embedding
Query
Reports
Saved Queries
Sharing
Themes
Reference
Connector matrix
Keyboard shortcuts
Select theme
Dark
Light
Auto
Lower
Lower(text)
· Scalar
SQL
LOWER
.
Related
Section titled “Related”
Upper
Function index