Skip to content

Product
Pricing
Solutions
Resources
Sign-In
Search for:

Product
Pricing
Solutions
Resources
Sign-In
Search for:

Product
Pricing
Solutions
Resources
Sign-In

PlaidLink (Remote Agents)

Home/PlaidLink (Remote Agents)

PlaidCloud

Getting Started

Dashboards

Learning Dashboard
Dashboards

Documents

Temporary Storage
Managing Accounts
File and Folder Management
Document

Identity

Member Management
Member Authentication
Managing Security
Identity

Organization & Workspaces

Workspaces
Organizations and Workspaces
Organizations

Projects

Projects
Project Log
Managing Tables
Managing Projects
Managing Hierarchies
Managing Data Editors
Archives

Tools

Tools
PlaidLink Agents
Message Queues
Event Scheduler
Data Connections

Workflows

Jupyter

JupyterLab
Jupyter Notebook
Jupyter Console
Jupyter

Expression & Filter Functions | General Usage

Text Expressions
PostGIS
Mathematics Expressions
Filters
Expressions
Dates and Time Expressions
Data Type Expressions
Conditionals

Expressions & Filter Functions | Arrays

func.unnest
func.string_to_array

Expressions & Filter Functions | Conditions

or_
not_
func.coalesce
case
and_

Expressions & Filter Functions | Conditions on Columns

column.startswith
column.notlike
column.notin_
column.notilike
column.like
column.isnot
column.is_
column.in_
column.ilike
column.endswith
column.contains
column.between
column.any_

Expressions & Filter Functions | Conversions

func.to_timestamp
func.to_number
func.to_date
func.to_char
cast

Expressions & Filter Functions | Dates

func.transaction_timestamp
func.timeofday
func.statement_timestamp
func.now
func.justify_interval
func.justify_hours
func.justify_days
func.isfinite
func.extract
func.date_trunc
func.date_part
func.current_timestamp
func.current_time
func.current_date
func.clock_timestamp
func.age

Expressions & Filter Functions | JSON

json_object_keys
json_extract_path_text
json_extract_path
json_each_text
json_each
json_array_elements
array_to_json

Expressions & Filter Functions | Math

func.width_bucket
func.trunc
func.sqrt
func.sign
func.setseed
func.safe_divide
func.round
func.random
func.radians
func.power
func.pi
func.mod
func.log
func.ln
func.least
func.greatest
func.floor
func.exp
func.degrees
func.ceiling
func.ceil
func.cbrt
func.abs

Expressions & Filter Functions | PostGIS

Expressions & Filter Functions | Summarize

func.variance
func.var_samp
func.var_pop
func.sum
func.stdev_samp
func.stdev_pop
func.stdev
func.min
func.median
func.max
func.last
func.first
func.count
func.avg

Expressions & Filter Functions | Text

Expressions & Filter Functions | Trigonometry

func.tan
func.sin
func.cot
func.cos
func.atan2
func.atan
func.asin
func.acos

Expressions & Filter Functions | Window

func.sum
func.row_number
func.rank
func.percent_rank
func.ntile
func.min
func.max
func.lead
func.last_value
func.lag
func.first_value
func.dense_rank
func.cume_dist
func.count
func.avg

PlaidCloud Office Add-in (Excel Add-in)

Excel Quick Start

PlaidXL for SAP PCM

Using with SAP PCM
Using with Analyze Toolbox
PlaidXL Ribbons
PlaidXL Report Design
PlaidXL Installation
PCM Reassignment Value Methods
PCM Model Retrieval Methods
PCM Data WriteBack Methods
PCM Data Retrieval Methods
Member Selection
Managing Data Updates
Getting Started
Formula Builder
Connections & Security
Automated Drill Down

PlaidLink (Remote Agents)

Windows Installation
PlaidLink User Guide
How-To
Getting Started
Configuration in PlaidCloud

Command Line Interface (CLI)

Utilities
Remote Procedure Call (RPC)
Getting Started

Home
Documentation
PlaidLink (Remote Agents)

PlaidLink (Remote Agents)

Windows Installation
PlaidLink User Guide
How-To
Getting Started
Configuration in PlaidCloud

Sitemap

PlaidCloud Web Based Analytics On Demand
News
- Company Blog
- Engineering Blog
Product
Pricing
Solutions

Useful Links

PlaidCloud Web Based Analytics On Demand
Manage Account
Documentation
API
Help
Carbon Neutral Infrastructure
Privacy Policy
Terms of Service
Global Datacenters
Security

What we’re talking about

🚀PlaidCloud News - New Updates on May 14th, 2021 - mailchi.mp/9773428c4dc4/p…
5 months ago
🚀PlaidCloud Updates (BETA Now Open) - April 15th, 2021 - mailchi.mp/415e811ae6b4/p…
6 months ago
PlaidCloud Service - Secure Certificate Issue - mailchi.mp/3928998f75ce/p…
7 months ago
PlaidCloud Service - Secure Certificate Issue - mailchi.mp/0c44bc0c813a/p…
7 months ago
🚀PlaidCloud Updates (BETA Now Open) - Feb 16th, 2021 - mailchi.mp/19efd79e48f1/p…
7 months ago

Copyright 2008 - Tartan Solutions, Inc. | All Rights Reserved

Twitter Facebook LinkedIn YouTube Vimeo

This website uses cookies and third party services. Ok