Search
Palantir
Documentation
Documentation
Apollo
Gotham
Search documentation
Search
karat
+
K
API Reference ↗
Send feedback
en
en
jp
kr
zh
AB
XY
AB
XY
AB
XY
AB
XY
AB
XY
AB
XY
AB
XY
Capabilities
AI Platform (AIP)
Data connectivity & integration
Model connectivity & development
Ontology building
Developer toolchain
Use case development
Analytics
Product delivery
Security & governance
Management & enablement
Getting started
Platform updates
Announcements
Release notes
Analytics
Overview
Types of analysis
Analytical results
Dashboards
Reporting
Models
Datasets and Object Sets
Exporting outputs
Reusable logic
Release notes ↗
Applications
Contour
Overview
Getting started
Core concepts
FAQ
Analysis
Create a path
Parameterize your analysis
Switch to aggregated data
Share and collaborate on an analysis
Share results
Boards
Overview
Add a board
Filter data
Join datasets
Verify results
Board descriptions
Map board
Dashboards
Overview
Getting started
Datasets
Save as dataset
Change input dataset version
Project references
Export logic to Pipeline Builder
Expressions
Overview
Use the expression board
Syntax and supported functions
Array functions
Derive relative dates
Window functions
Performance and correctness
Optimizing your analysis
Non-determinism in Contour
Timezones in Contour
Administration
Compute Usage
Quiver
Overview
Getting started
Core concepts
Best practices
Analysis
Canvas mode
Graph mode
Data model
Analysis toolbars
Parameters
Settings
Saving and sharing
Global identifiers
AIP features
Formulas
Formula syntax
Objects
Add objects
Filter object sets
Search around to linked objects
Visualize objects with charts
Drill down to objects and properties
Export an object set
Time series
Add time series
Visualize time series
Time series X/Y plots
Transform time series
Time series aggregations
Time and value ranges
Interpolation
Search for anomalies
Analyze events data
Compare series in relative time
Batch analyze time series
Time series metrics
Parameterize and pivot time series
Reference profiles
Transform tables
Vega plots
Dashboards
Overview
Create a dashboard
Publish and share a dashboard
Use a dashboard within an analysis
Embed in a Workshop module
Add to a Notepad document
Embed in an Object View
Add to a Carbon workspace
Add Quiver dashboard to a Marketplace product [Beta]
Convert a canvas template [Deprecated] to a dashboard
Visual functions
Overview
Create and use visual functions
Card references
Index of cards
Objects
Time series
Event sets
Materializations
Charts
Tables
Numeric
String
Date/Time
Boolean
Array
Writeback
Display
Transform references
Index of transform table transformations
Edit columns
Group
Join
Filter
Null/error handling
Number operations
Number comparisons
String operations
String comparisons
Time operations
Time comparisons
Boolean operations
Boolean comparisons
Array operations
Range operations
Time series operations
User information
Functions
Detailed card index
Action button
After
Align series to event set
Align to date
Array contains
Array end
Array join
Array length
Array sort
Array start
Backing object from time series
Bar chart
Before
Between (inclusive)
Bollinger bands
Boolean formula
Boolean parameter
Categorical formula plot
Categorical plot from materialization
Categorical plot from transform table
Categorical scatter plot
Ceiling
Coalesce
Coalesce time series
Code function categorical plot
Code function object set
Code function value
Code function time series
Combine time series
Concatenate
Contains
Correlation matrix
Create array
Create range
Create values
Cross filter
Cross join transform tables
Cumulative aggregate
Custom plot (transform table)
Date difference
Date/time parameter
Date/time range parameter
Day of month
Day of week
Day of year
Day to date
Deduplicate event set
Defined by property
Derived property from function on objects
Derivative
Does not contain
DSP filter
Duration unit parameter
Edit values
Ends with
Enum value at time
Equal to
Event comparison plot
Event indicator series
Event set from ranges
Event set from tabular data
Event statistics
Expression
Extract time series bound
Filter materialization
Filter object set
Filter time series
Filter transform table
Find and replace
Floor
Foundry dataset [Beta]
Greater than
Greater than or equal to
Group by
Grouped time series plot
Heat grid
Hour of day
Import saved object set
Integral
Is
Is not
Join materializations
Join to linked objects
Join to transform table
Joined group by
Latest value for enum time series
Less than
Less than or equal to
Line chart
Linear aggregation
Linked event set
Linked series aggregation
List
Manual entry transform table
Map
Media property
Month
Month to date
Multi chart time series
Multipass attribute
Not equal to
Not on
Number array aggregation
Number to date
Numeric aggregation
Numeric aggregation (materialization)
Numeric formula
Numeric parameter
Numeric range parameter
Numeric range to date range
Numeric series formula
Numerical scatter plot
Object property
Object selector
Object set materialization
Object view
On
On or after
On or before
Overlay chart
Periodic aggregate
Pie chart
Pivot table
Property value select parameter
Range end
Range start
Reference profile bounds
Relative time
Rename columns
Rolling aggregate
Row number
Sample
Scatter plot regression
Segment formula plot
Segment statistics
Select columns
Set math
Set math (materialization)
Shift date/time
Shift time series
Split
Starts with
Static time
Status filter
Stepped array
String array parameter
String parameter
String selector
String to Boolean
String to date
String to number
Strings to booleans
Strings to dates
Strings to numbers
Substring
Switch to linked object set
Table
Tabular time series
Time series bounds
Time series distribution
Time series end date
Time series forecast
Time series formula
Time series heat grid
Time series numeric aggregation
Time series property
Time series regression coefficients
Time series regression
Time series scatter plot
Time series search
Time series start date
Time series sync
Time series unit
Time shift event set
To lower case
To upper case
Transform table
Transform table aggregation
Transform table column values
Transform table row selector
Union (transform table)
Unique column values (materialization)
Unique property values
Unique values
Value at index
Value at time
Vega plot
Visual function boolean
Visual function date/time
Visual function metric
Visual function property select
Visual function string
Visual function time range
Waterfall plot
Week to date
X/Y range parameter
Year
Year to date
Code Workbook [Legacy]
Overview
Getting started
Core concepts
Keyboard shortcuts
FAQ
Workbooks
Overview
Supported languages
Inputs and outputs
Console
Global code
Duplicate nodes
Moving to production
Transforms
Overview
Visualize data
Present visualizations
Access unstructured files
Spark
Transforms FAQ
Templates
Overview
Getting started
Multi-node templates
Suggested templates
Environment
Overview
Code Workbook profiles
View resolved environment
Batch builds and interactive builds
Environment creation overview
Session history and session pinning
Troubleshooting guide
Branching
Overview
Getting started
Merging branches
Choose imported dataset branch
Datasets
Optional data persistence
Project references
Code repositories
Comparison: Code Repositories vs. Code Workbook vs. Code Workspaces
Exporting to a Code Repository
Hidden code repositories
PySpark reference
SparkR reference
R Filesystem API
Available fonts
Notepad
Overview
Getting started
AIP features
Markdown features
Add documents and templates to a Marketplace product [Beta]
Documents
Embed widgets
Lock widget data
Version history
Document outline
Export to PDF
Custom functions
Templates
Notepad templates
Create a template
Add template inputs
Connect inputs to widget
Publish a template
Configure space template generation limits
Integrate with Workshop
Show documents linked to objects
Embed a document
Generate and export documents from templates
Export existing Notepad documents
Widgets
Anchor link
Resource link
Current date
User mention
LaTeX
Page break
Horizontal rule
Image
Table
Object property
Object card
Object media preview
Contour chart
Code Workbook chart
Quiver chart
Quiver dashboard
Map
Value embed
Functions
Section generator
Table row generator
Conditional section
Reports [Sunset]
Overview
Reports
Convert legacy reports
Add a title
Add content
Add content from other Foundry applications
Reorder widgets
Change width and height
Show and hide content
Update data automatically
Duplicate a report
Parameters
Overview
Add a parameter
Change a parameter
Show suggested values
Merge multiple parameters
Use a parameter as a widget title prefix
Sharing and export
Share a report with others
Collaborate on a report
Export to PDF or PowerPoint
Copy a report's text as markdown
Export a board's data to CSV
Fusion
Overview
Sheets
Overview
Find and use data
Create and use table regions
Create templates
Format cells
Dropdowns, locked cells, and links
Data updates and edit history
Presentation view
Formulas
Overview
Validate results
Boolean logic
Perform Actions
Visualize time series
Function library
Datasets
Sync a table to a dataset
Resync a table to a dataset
Import XLS documents
Index datasets
Lookup datasets
Project scope
Forms [Sunset]
Overview
Core concepts
Validators
Transforms
Multiplicity
Permissions
Configure forms
Create a form
Sheets
Simple fields
Data-backed fields
Auto-populating fields
Attachments field
Code Editor
Generate primary key
Manage forms
Receive notifications
Share with other users
Review and edit responses
Integrate with other applications
FAQs
Connectivity: SQL & BI
Overview
Architecture
Power BI®
Overview
Setup
REST Connector setup
Getting started
FAQs
Tableau
Overview
Setup
Getting started
Tableau Server setup
OAuth setup
Microsoft Report Builder
Overview
Setup
Getting started
Excel
Qlik Sense
Overview
Server setup
Getting started
MicroStrategy
ODBC & JDBC drivers for Foundry datasets
Downloads
Guides
Identify a dataset's RID or filepath
Troubleshooting issues
Hide sidebar
Analytics
Quiver
Detailed card index
Hour of day
Hour of day
Returns the hour of day from a date as a number.
Input type
Time
Output type
Number
Usage information
Functionality
Availability
Standard Quiver card
Supported
Transform table transform
Supported
←
PREVIOUS
Heat grid
NEXT
Import saved object set
→
Contents
Hour of day
Input type
Output type
Usage information