community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Plotting Aggregated Values in a Date Range

scott123
5 - Atom
‎12-04-2024 01:16 PM

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!   

 

ProjectStart EndConsumption
ABC12/1/202412/31/2024100
EFG12/7/20241/3/2025200
HIJ12/14/202412/28/2024300

 

DateTotal Consumption
12/1/2024100
12/2/2024100
12/3/2024100
12/4/2024100
12/5/2024100
12/6/2024100
12/7/2024300
12/8/2024300
12/9/2024300
12/10/2024300
12/11/2024300
12/12/2024300
12/13/2024300
12/14/2024600
12/15/2024600
12/16/2024600
12/17/2024600
12/18/2024600
12/19/2024600
12/20/2024600
12/21/2024600
12/22/2024600
12/23/2024600
12/24/2024600
12/25/2024600
12/26/2024600
12/27/2024600
12/28/2024600
12/29/2024300
12/30/2024300
12/31/2024300
1/1/2025200
1/2/2025200
1/3/2025200
Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

2 REPLIES 2
CoG
14 - Magnetar
‎12-04-2024 03:52 PM

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:

 

Screenshot.png

 

Hope this helps and Happy Solving!

Sample Workflow.yxmd
Reply
scott123
5 - Atom
‎12-04-2024 07:02 PM

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

Reply
0 Likes
industry user group interest form
Labels
Top Solution Authors
View All