Less
  • 👋Welcome to Less
  • 🏃 Getting Started
    • A Quick Overview
    • Storage
    • Connectors
    • Modelling
  • 🏃 Exercises
    • Data-Driven Ecommerce
      • Hints
    • Automated Financial Analysis
      • Hints
        • Part 1 - Profit & Loss
        • Part 2 - Metrics
        • Part 3 - Accrual-Based Accounting
    • AI-driven product reviews
      • Hints
  • 🔌 Connectors
    • Intro to Connector
    • Connector Guides
      • AWS Billing
      • Billy
      • Bing Ads
      • Python Connection
      • Customer.io
      • CVR Virk
      • DAWA
      • Dinero
      • DMI
      • ECB Exchange Rates
      • Meta Ads
      • Facebook Page Insights
      • Google Ads
      • Google Analytics
      • Google Sheets
      • Heap.io
      • HubSpot
      • HubSpot Email Marketing (coming soon!)
      • Instagram Page Insights
      • ISO Calendar
      • LinkedIn Ads
      • Mailchimp
      • Matomo
      • Marathon (coming soon!)
      • Mixpanel
      • MongoDB
      • MSSQL
      • MySQL
      • PostgreSQL
      • Salary.dk
      • Slack
      • Stripe
      • Trustpilot (coming soon!)
      • WooCommerce (coming soon!)
      • Zettle
  • 🧊 Modelling
    • Intro to the Canvas
    • Action Guides
      • Basics
        • Input
        • Output
        • Fill
        • Filter
        • Formats
        • Limit
        • Rename
        • Replace
        • Pick
        • Sort
        • Text Transform
        • Unique
      • New Columns
        • Compare
        • Cumulative
        • Date Difference
        • Date Format
        • Date Math
        • Difference
        • Calculate
        • IF Column
        • Text Column
        • Parse JSON
        • Row ID
        • Running Interval
        • Split Columns
      • Reshape
        • Pivot
        • Group By
        • Transpose
      • Merge
        • Append
        • Combine
        • Stack
  • ⛔ Advanced Databases & Security
    • Security
    • Link Database
    • Whitelisting of IPs
  • 🔐 Roles and Permission
    • Basics
    • Abilities
    • Roles
    • Groups
  • 📞 REST API (beta)
    • Basics
    • Endpoints
Powered by GitBook
On this page
  1. 🧊 Modelling
  2. Action Guides
  3. New Columns

Cumulative

Perform cumulative calculations

PreviousCompareNextDate Difference

Last updated 2 years ago

You can use the Cumulative Action to calculate a cumulative running sum or average. It can be helpful before calculating understanding percentiles and calculating contributions to overall sales. Maybe even or segmentations. See the video below for an example.

Remember to sort your data in a meaningful way before performing cumulative calculations. Maybe by dates or by volume.

Whale Curve
ABC
The Cumulative Action exemplified with a Whale Curve calculation