How to calculate TCV (total contract value) in PostgreSQL

Make the most of your PostgreSQL data

What is TCV (total contract value) ?

TCV (total contract value) is the total value of the contract. This includes all contract no matter their duration, so if you have signed a contract for 1 month and one for 1 year the TCV will be the sum of all contract value. Make sure TCV also includes the value from one-time charges, professional service fees, and recurring charges.

What is PostgreSQL ?

PostgreSQL is a powerful, open source object-relational database system with over 30 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance.

How to calculate TCV (total contract value) in PostgreSQL ?

It can be difficult to calculate TCV (total contract value) directly inside of PostgreSQL; that's where Whaly comes in.

Whaly helps you build models on top of PostgreSQL and many other solutions. You simply connect Whaly to your PostgreSQL account, and then you can create your formula in Whaly to calculate your TCV (total contract value).

How does Whaly work ?

01
Self-Service Business Intelligence
Our self-service exploration tool is designed with business teams in mind, with the goal of empowering non-technical users to answer their own data questions and run queries autonomously. Our familiar, intuitive, drag & drop experience maximizes adoption across the business, leading to more data-driven decisions.
Visualize your data
02
Declarative Modeling
Our modeling workbench is tailored to data teams, allowing them to implement business logic, create the semantic layer, and model data from different sources using SQL. Our bespoke tool enables data teams to set up a solid data foundation that can be easily governed as you scale.
Build your metrics
03
Get up and running ASAP
Whaly comes with some quick-start ETL connectors included with our platform, to help you get up and running in record time. For connectors that we don’t offer, we’ll connect you to your best-suited ETL partner to ensure that your BI projects are always complete.
Benoit Prigent
Benoit Prigent
Co Founder / CPO @ Lokki
Whaly helped us create metrics on top of 6 data sources in a matter of days instead of months without technical knowledge required !!
Edouard Mascré
Edouard Mascré
Co Founder @ Pennylane
We leveraged Whaly on the Sales team to build and share dashboards with ton of partners without having to continuously update things on many spreadsheets. It also gives us deeper insights on sales activity. The dashboards built can be shared with everyone in the company. Whaly saves us hours of data wrangling every day.
Benjamin Cambier
Benjamin Cambier
Co Founder @ Mansa
Mansa grew really fast in the past months and we were in urge of more precise metrics, especially for acquisition and deals analysis. Our engineering team was already swamped so we started our data analysis with Whaly. We compute our CAC per acquisition channel and understood at what stage the pipeline is under performing in minutes.
Quentin Lebret
Quentin Lebret
VP Operations @ Klox
Whaly gave us the tools to understand how our users consume our product and helped us create a better experience for our users.
Julio Cesar Rodriguez
Julio Cesar Rodriguez
Operation Automation Specialist @ Career Karma
Whaly helped us create actionable experience for our SDR based on data our data team has prepped for us in dbt.
Hugo Cornu
Hugo Cornu
Head of Growth @ Klox
Whaly helped us transform the way we work with data. We now back all our decision with data and can make informed decisions at any time