Plotting Aggregated Values in a Date Range

[scott123]

Hi, I am looking for an Alteryx solution to show daily aggregated consumption using project data to display as such in the second table.  Thank you in advance!   

Project	Start	End	Consumption
ABC	12/1/2024	12/31/2024	100
EFG	12/7/2024	1/3/2025	200
HIJ	12/14/2024	12/28/2024	300

Date	Total Consumption
12/1/2024	100
12/2/2024	100
12/3/2024	100
12/4/2024	100
12/5/2024	100
12/6/2024	100
12/7/2024	300
12/8/2024	300
12/9/2024	300
12/10/2024	300
12/11/2024	300
12/12/2024	300
12/13/2024	300
12/14/2024	600
12/15/2024	600
12/16/2024	600
12/17/2024	600
12/18/2024	600
12/19/2024	600
12/20/2024	600
12/21/2024	600
12/22/2024	600
12/23/2024	600
12/24/2024	600
12/25/2024	600
12/26/2024	600
12/27/2024	600
12/28/2024	600
12/29/2024	300
12/30/2024	300
12/31/2024	300
1/1/2025	200
1/2/2025	200
1/3/2025	200

[CoG · Accepted solution]

Simple workflow for this problem. Generate Rows will generate all the dates in the range given for each record, which can then be aggregated via the Summarize Tool:

Hope this helps and Happy Solving!

[scott123]

Spot on. I am admittedly weak in this area. Thank you!