Palantir
  • Documentation
    • Documentation
    • Apollo
    • Gotham
  • Search documentation
    karat

    +

    K

    API Reference ↗Send feedback
    • 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
      • 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
        • Transform time series
        • Time series aggregations
        • Time and value ranges
        • Interpolation
        • Analyze events data
      • 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 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 transformation
        • 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
    AnalyticsQuiverTransform referencesTime series operations

    Time series operations

    Back to: Index of transforms

    Transforms in this section operate on a time series. Learn more about how to search for and add a transformation.

    Many of these transformations can be saved as derived series for use outside of Quiver.

    • Linked time series sensor
    • Group to time series
    • Union time series group
    • Time series scatter
    • Scatter regression
    • Time series group linear aggregation
    • Custom plot
    • Time series numeric aggregation
    • Time series start date
    • Time series end date
    • Value at time
    • Enum value at time
    • Latest value for enum time series
    • Time series unit
    • Combine time series
    • Time series regression coefficients
    • Rolling aggregate
    • Periodic aggregate
    • Cumulative aggregate
    • Integral
    • Derivative
    • Shift time series
    • Align to date
    • Segment transformation
    • Sample
    • Digital signal processing (DSP) filter
    • Time series regression
    • Relative time series
    • Filter time series
    • Time series formula
    • Event statistics
    ←
    PREVIOUSRange operations
    NEXTUser information
    →

    © 2025 Palantir Technologies Inc. All rights reserved.

    Cookies Statement ↗Privacy Statement ↗