Sums per subscriber across any selected date range

user04612 · February 12

We have a dataset that lists subscribers and their purchases over time.

We'd like to choose any data range and get back an aggregation for each subscriber in that date range (just a table with all subscribers with purchase totals in that range)

Not sure the best way to achieve this in DOMO.

So in the below example,

subscriber 7710, date range for all of 2025, it would return $83.16

and for 9/1/24 thru 1/125 it would be $322.74

and while we're at it, regardless of the date range, could a column be added to show each subscriber's lifetime purchase amounts?

thanks,

Brian

DavidChurchman · February 12

For the first part of your question, you just need to use a sum as your aggregation, and then you can put a quick-filter on your date:

The second part is slightly harder, as you need the total to stay the same regardless of filter. You can use a FILTER NONE in a FIXED function to do that: https://domo-support.domo.com/s/article/4408174643607?language=en_US

DavidChurchman · February 12

For the first part of your question, you just need to use a sum as your aggregation, and then you can put a quick-filter on your date:

The second part is slightly harder, as you need the total to stay the same regardless of filter. You can use a FILTER NONE in a FIXED function to do that: https://domo-support.domo.com/s/article/4408174643607?language=en_US

user04612 · February 13

thank you! everything working perfectly!

I actually just added Lifetime to my sql, and even though it is repeated for each line, when I do the sum aggregation, the lifetime column shows the correct value.

I appreciate your fast response.

Sums per subscriber across any selected date range

Best Answer

Answers

Categories