Cumulative Chart of Users over time [Solved]

Hi @devin.fraze

i’m trying to do something similar and having some trouble…

I’d like to make a graph of a user’s cumulative carbon offset over time in weekly summations - a calculated field that exists for each payment, within our payments table, so it’s equivalent in practice to finding their cumulative payments over time, just multiplied by some other factor.

I have a payments table (we call it a subscription table) with this info. Here’s what my database has saved, what my query is, and the blank output I’m getting:



(when I add a :sum aggregation here, it just makes everything break :man_shrugging:)

The output,


and what is saved in my database for this user, hence what I’m actually expecting…
image

Any ideas how to fix this?