Calculating the cumulative sum of a value for a given time window
I am trying to calculate the cummulative monthly sum of a specific value but with the caveat that said value only exists for a particular time window. There will be an associated startDate and an associated endDate for each value. An example data table detailing an example data set is given here:
A table detailing the resulting calculated cummulative sum is given here:
And the resulting plot I would be looking for is given here:
Having reproduced this propblem in Excel. (N.B. that I have used quarters as an example, but I would need the granularity to be monthly).
May I please have advice on how best to accomplish this within Domo. I don't believe that this should be hard but I am really struggling. Would you recomend using the MySQL Magic ETL to create a new data series or can I do this within the analyser window by making use of filters (for example)?
Thank you in advance.
Regards,
Matthew
Comments

Hi,
Is anyone able to help with this request?
Thanks,
0 
Hello!
You can create this referenced chart by making a beast mode calculation that contains the following:
CASE
WHEN `startDate` LIKE '%1Q17%'
THEN 'Quarter 1'
WHEN `startDate` LIKE '%2Q17%'
THEN 'Quarter 2'
*(...etc)
ELSE 'Quarter 0'
END
You can then have your 'value' as the Y Axis, with a SUM to represent the total values for each quarter or date range.
0
Categories
 11K All Categories
 5 Private Company Board
 2 APAC User Group
 12 Welcome
 42 Domo News
 9.9K Using Domo
 2K Dataflows
 2.5K Card Building
 2.2K Ideas Exchange
 1.2K Connectors
 349 Workbench
 266 Domo Best Practices
 11 Domo Certification
 474 Domo Developer
 51 Domo Everywhere
 110 Apps
 725 New to Domo
 85 Dojo
 Domopalooza
 1.1K 日本支部
 4 道場日本支部へようこそ
 28 お知らせ
 65 Kowaza
 301 仲間に相談
 662 ひらめき共有