Explore practical examples of using derived columns to solve common data challenges, such as adjusting MRR with discounts, categorizing customers based on subscription duration, and identifying overdue invoices. These examples demonstrate how to apply mathematical, string, and date functions to derive actionable insights from your data.
MRR * (1 - discount_percentage)
MRR
of $1200
has a 10%
discount, the formula 1200 * (1 - 0.10)
calculates the adjusted MRR as $1080
.if(diff_days(today(), activated_at) > 365, "Long-term", "New")
if(diff_days(due_date, today()) > 0, "Overdue", "On Time")
due_date
is 2023-06-01
and today is 2024-02-20
, diff_days(2023-06-01, today())
would label the invoice as “Overdue”.diff_days(today(), activated_at)
activated_at
column which contains the activation date of each subscription.diff_days(today(), A2)
where A2 contains the activated_at
date for a subscription.if(MRR >= 1000, "Enterprise", "SMB")
if(B2 >= 1000, "Enterprise", "SMB")
where B2 contains the MRR
for a subscription.