Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Summarizing Stacked Data

AlisonK39
7 - Meteor

Hi, 

 

I've tried to find an answer on here - but maybe overthinking this issue.  I have two sets of data stacked - with the common factor being the "Contract" and I want to summarize the data at the Contract level.  Using the Summarize tool doesn't seem to be working for me, but I may be approaching it wrong.  It seems like this should be pretty basic, but I'm still somewhat "new" to Alteryx.  

 

 

AlisonK39_0-1610579884524.png

 

Thanks! 

 

2 REPLIES 2
Qiu
21 - Polaris
21 - Polaris

@AlisonK39 
Summarize should do the work.

Maybe your Team Hours columns are not numeric fields?

0114-AlisonK39.PNG

AlisonK39
7 - Meteor

Thanks so much!  I had previously tried the Summarize tool, but wasn't working as expect.  I just ran the workflow and the hours now look correct across reporting.  Appreciate the help! 

 

-Alison

Labels