-
Null values in date fields
Hi all - running into a simple count issue here wanting to count all Invoice IDs where the date fields discarded_at and archived_at have no value. Summing invoice amounts with this syntax works - sum (case when discarded_at is NULL and archived_at is NULL then Invoice Amount (cents)/100 else 0 END) When I try to do the…
-
Calculated Field
Hi there - I am trying to add another constraint to a layered case statement but it does not seem to be working. The below calculated field sums total payment volume correctly - when I then add a filter onto my table for Payment Service = manual it sums the correct amount of manual payments. Sum(CASE when `type` =…
-
Null value
Very basic question here, trying to create a calculated column returning "TRUE" if another column has a value and false if not - neither of these are working. I assume my language is not correct here? Thanks case when `Intro Call Held Date (Cleaned)`= value then true else false end or case when `Intro Call Held Date…
-
Calculated Column Syntax Error
Trying to create column(s) in my data set to see if payments were paid early, on their due date, or late. I already have a column 'Due Date Minus Payment Date' 'DATEDIFF(`due_date`,`payment_date`) but for some reason this next column keeps giving me an error saying "oops something went wrong.) It seems incredibly basic, I…
-
Count of date instances "last week"
Trying to visualize a sales funnel via Hubspot data and running into issues. I need to create a calculated column counting instances that a date field falls in "last week". Is there a quick calc for something like that?
-
Calculated Field - Outstanding Invoice Count with date constraints
Hi there - likely easy one here - I am trying to create a calculated field to count outstanding unpaid invoices that are either before their due dates or within 14 days of their due dates. When an invoice is unpaid, the "type" field is empty (i.e. no payment type.) I've also created a custom calculated column with the…
